{
  "═════ 1. БАЗА ДАННЫХ (УНИВЕРСАЛЬНАЯ) ═════": {
    "prefix": "db-skeleton",
    "body": [
      "-- ========== УНИВЕРСАЛЬНАЯ БД ДЛЯ ЭКЗАМЕНА ==========",
      "-- CREATE DATABASE exam_db;",
      "-- USE exam_db;",
      "",
      "-- 1. Таблица пользователей",
      "CREATE TABLE users (",
      "    id INT AUTO_INCREMENT PRIMARY KEY,",
      "    login VARCHAR(50) UNIQUE NOT NULL,",
      "    full_name VARCHAR(150) NOT NULL,",
      "    email VARCHAR(100) UNIQUE NOT NULL,",
      "    phone VARCHAR(20) NOT NULL,",
      "    address TEXT,",
      "    password VARCHAR(255) NOT NULL,",
      "    role ENUM('user', 'admin') DEFAULT 'user',",
      "    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP",
      ");",
      "",
      "-- 2. Таблица товаров/услуг (универсальная)",
      "CREATE TABLE items (",
      "    id INT AUTO_INCREMENT PRIMARY KEY,",
      "    name VARCHAR(200) NOT NULL,",
      "    description TEXT,",
      "    price DECIMAL(10,2) NOT NULL,",
      "    stock INT DEFAULT 0,",
      "    image VARCHAR(255),",
      "    category VARCHAR(100),",
      "    size VARCHAR(50),",
      "    color VARCHAR(50),",
      "    is_active BOOLEAN DEFAULT TRUE",
      ");",
      "",
      "-- 3. Таблица заказов/бронирований (универсальная)",
      "CREATE TABLE orders (",
      "    id INT AUTO_INCREMENT PRIMARY KEY,",
      "    user_id INT NOT NULL,",
      "    order_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,",
      "    total_amount DECIMAL(10,2) NOT NULL,",
      "    status ENUM('new', 'confirmed', 'processing', 'shipped', 'completed', 'cancelled') DEFAULT 'new',",
      "    delivery_address TEXT,",
      "    delivery_time VARCHAR(100),",
      "    payment_method VARCHAR(50),",
      "    notes TEXT,",
      "    FOREIGN KEY (user_id) REFERENCES users(id)",
      ");",
      "",
      "-- 4. Таблица позиций заказа",
      "CREATE TABLE order_items (",
      "    id INT AUTO_INCREMENT PRIMARY KEY,",
      "    order_id INT NOT NULL,",
      "    item_id INT NOT NULL,",
      "    quantity INT DEFAULT 1,",
      "    price DECIMAL(10,2) NOT NULL,",
      "    FOREIGN KEY (order_id) REFERENCES orders(id),",
      "    FOREIGN KEY (item_id) REFERENCES items(id)",
      ");",
      "",
      "-- 5. Таблица отзывов",
      "CREATE TABLE reviews (",
      "    id INT AUTO_INCREMENT PRIMARY KEY,",
      "    user_id INT NOT NULL,",
      "    item_id INT NOT NULL,",
      "    rating INT CHECK (rating BETWEEN 1 AND 5),",
      "    comment TEXT,",
      "    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,",
      "    FOREIGN KEY (user_id) REFERENCES users(id),",
      "    FOREIGN KEY (item_id) REFERENCES items(id)",
      ");",
      "",
      "-- ========== ТЕСТОВЫЕ ДАННЫЕ ==========",
      "-- Админ (пароль: admin123, логин: admin)",
      "-- INSERT INTO users (login, full_name, email, phone, password, role) VALUES",
      "-- ('admin', 'Администратор', 'admin@exam.ru', '+7(999)-000-00-00', MD5('admin123'), 'admin');",
      "",
      "-- Тестовые товары",
      "-- INSERT INTO items (name, description, price, stock, category) VALUES",
      "-- ('Товар 1', 'Описание товара 1', 1000.00, 10, 'Категория 1'),",
      "-- ('Товар 2', 'Описание товара 2', 2000.00, 5, 'Категория 1');"
    ],
    "description": "Универсальная структура БД (5 таблиц)"
  },

  "═════ 2. config.php (ПОДКЛЮЧЕНИЕ К БД + СЕССИИ) ═════": {
    "prefix": "config-skeleton",
    "body": [
      "<?php",
      "// ========== CONFIGURATION FILE ==========",
      "session_start();",
      "",
      "// Database connection",
      "define('DB_HOST', 'localhost');",
      "define('DB_NAME', 'exam_db');",
      "define('DB_USER', 'root');",
      "define('DB_PASS', '');",
      "",
      "try {",
      "    \\$pdo = new PDO('mysql:host=' . DB_HOST . ';dbname=' . DB_NAME . ';charset=utf8', DB_USER, DB_PASS);",
      "    \\$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);",
      "    \\$pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);",
      "} catch (PDOException \\$e) {",
      "    die('Ошибка подключения к БД: ' . \\$e->getMessage());",
      "}",
      "",
      "// Helper functions",
      "function isLoggedIn() {",
      "    return isset(\\$_SESSION['user_id']);",
      "}",
      "",
      "function isAdmin() {",
      "    return isset(\\$_SESSION['role']) && \\$_SESSION['role'] === 'admin';",
      "}",
      "",
      "function redirect(\\$url) {",
      "    header('Location: ' . \\$url);",
      "    exit();",
      "}",
      "?>"
    ],
    "description": "config.php - подключение к БД и сессии"
  },

  "═════ 3. РЕГИСТРАЦИЯ (с валидацией) ═════": {
    "prefix": "register-skeleton",
    "body": [
      "<?php",
      "require_once 'config.php';",
      "",
      "\\$errors = [];",
      "\\$success = false;",
      "",
      "if (\\$_SERVER['REQUEST_METHOD'] === 'POST') {",
      "    \\$login = trim(\\$_POST['login'] ?? '');",
      "    \\$full_name = trim(\\$_POST['full_name'] ?? '');",
      "    \\$email = trim(\\$_POST['email'] ?? '');",
      "    \\$phone = trim(\\$_POST['phone'] ?? '');",
      "    \\$password = \\$_POST['password'] ?? '';",
      "    \\$confirm = \\$_POST['confirm_password'] ?? '';",
      "",
      "    // Валидация",
      "    if (strlen(\\$login) < 4) \\$errors[] = 'Логин должен быть не менее 4 символов';",
      "    if (!preg_match('/^[а-яА-ЯёЁ\\s]+$/u', \\$full_name)) \\$errors[] = 'ФИО должно содержать только кириллицу и пробелы';",
      "    if (!filter_var(\\$email, FILTER_VALIDATE_EMAIL)) \\$errors[] = 'Некорректный email';",
      "    if (!preg_match('/^\\+7\\(\\d{3}\\)-\\d{3}-\\d{2}-\\d{2}$/', \\$phone)) \\$errors[] = 'Телефон должен быть в формате +7(XXX)-XXX-XX-XX';",
      "    if (strlen(\\$password) < 6) \\$errors[] = 'Пароль должен быть не менее 6 символов';",
      "    if (\\$password !== \\$confirm) \\$errors[] = 'Пароли не совпадают';",
      "",
      "    // Проверка уникальности",
      "    \\$stmt = \\$pdo->prepare('SELECT id FROM users WHERE login = ? OR email = ?');",
      "    \\$stmt->execute([\\$login, \\$email]);",
      "    if (\\$stmt->fetch()) \\$errors[] = 'Логин или email уже занят';",
      "",
      "    if (empty(\\$errors)) {",
      "        \\$hashed = password_hash(\\$password, PASSWORD_DEFAULT);",
      "        \\$stmt = \\$pdo->prepare('INSERT INTO users (login, full_name, email, phone, password) VALUES (?, ?, ?, ?, ?)');",
      "        \\$stmt->execute([\\$login, \\$full_name, \\$email, \\$phone, \\$hashed]);",
      "        \\$success = true;",
      "        \\$_SESSION['message'] = 'Регистрация успешна! Теперь войдите.';",
      "        header('Location: login.php');",
      "        exit();",
      "    }",
      "}",
      "?>",
      "<!DOCTYPE html>",
      "<html lang='ru'>",
      "<head>",
      "    <meta charset='UTF-8'>",
      "    <meta name='viewport' content='width=device-width, initial-scale=1'>",
      "    <title>Регистрация</title>",
      "    <link href='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css' rel='stylesheet'>",
      "    <style>",
      "        body { background: linear-gradient(135deg, #667eea 0%, #764ba2 100%); min-height: 100vh; }",
      "        .card { animation: fadeIn 0.5s ease; }",
      "        @keyframes fadeIn { from { opacity: 0; transform: translateY(-20px); } to { opacity: 1; transform: translateY(0); } }",
      "    </style>",
      "</head>",
      "<body>",
      "    <div class='container mt-5'>",
      "        <div class='row justify-content-center'>",
      "            <div class='col-md-6'>",
      "                <div class='card shadow'>",
      "                    <div class='card-header bg-primary text-white text-center'>",
      "                        <h3>Регистрация</h3>",
      "                    </div>",
      "                    <div class='card-body'>",
      "                        <?php if (!empty(\\$errors)): ?>",
      "                            <div class='alert alert-danger'>",
      "                                <?php foreach (\\$errors as \\$error): ?>",
      "                                    <p class='mb-0'>• <?php echo \\$error; ?></p>",
      "                                <?php endforeach; ?>",
      "                            </div>",
      "                        <?php endif; ?>",
      "                        <form method='POST'>",
      "                            <div class='mb-3'>",
      "                                <label>Логин (мин. 4 символа)</label>",
      "                                <input type='text' name='login' class='form-control' required value='<?php echo \\$login ?? ''; ?>'>",
      "                            </div>",
      "                            <div class='mb-3'>",
      "                                <label>ФИО (кириллица)</label>",
      "                                <input type='text' name='full_name' class='form-control' required value='<?php echo \\$full_name ?? ''; ?>'>",
      "                            </div>",
      "                            <div class='mb-3'>",
      "                                <label>Email</label>",
      "                                <input type='email' name='email' class='form-control' required value='<?php echo \\$email ?? ''; ?>'>",
      "                            </div>",
      "                            <div class='mb-3'>",
      "                                <label>Телефон (формат: +7(XXX)-XXX-XX-XX)</label>",
      "                                <input type='tel' name='phone' class='form-control' placeholder='+7(999)-000-00-00' required value='<?php echo \\$phone ?? ''; ?>'>",
      "                            </div>",
      "                            <div class='mb-3'>",
      "                                <label>Пароль (мин. 6 символов)</label>",
      "                                <input type='password' name='password' class='form-control' required>",
      "                            </div>",
      "                            <div class='mb-3'>",
      "                                <label>Подтверждение пароля</label>",
      "                                <input type='password' name='confirm_password' class='form-control' required>",
      "                            </div>",
      "                            <button type='submit' class='btn btn-primary w-100'>Зарегистрироваться</button>",
      "                        </form>",
      "                        <div class='text-center mt-3'>",
      "                            <a href='login.php'>Уже есть аккаунт? Войти</a>",
      "                        </div>",
      "                    </div>",
      "                </div>",
      "            </div>",
      "        </div>",
      "    </div>",
      "    <script src='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js'></script>",
      "</body>",
      "</html>"
    ],
    "description": "Страница регистрации с полной валидацией"
  },

  "═════ 4. АВТОРИЗАЦИЯ ═════": {
    "prefix": "login-skeleton",
    "body": [
      "<?php",
      "require_once 'config.php';",
      "",
      "if (isLoggedIn()) {",
      "    redirect('index.php');",
      "}",
      "",
      "\\$error = '';",
      "",
      "if (\\$_SERVER['REQUEST_METHOD'] === 'POST') {",
      "    \\$login = trim(\\$_POST['login'] ?? '');",
      "    \\$password = \\$_POST['password'] ?? '';",
      "",
      "    \\$stmt = \\$pdo->prepare('SELECT * FROM users WHERE login = ? OR email = ?');",
      "    \\$stmt->execute([\\$login, \\$login]);",
      "    \\$user = \\$stmt->fetch();",
      "",
      "    if (\\$user && password_verify(\\$password, \\$user['password'])) {",
      "        \\$_SESSION['user_id'] = \\$user['id'];",
      "        \\$_SESSION['username'] = \\$user['login'];",
      "        \\$_SESSION['full_name'] = \\$user['full_name'];",
      "        \\$_SESSION['role'] = \\$user['role'];",
      "        \\$_SESSION['message'] = 'Добро пожаловать, ' . \\$user['full_name'] . '!';",
      "",
      "        if (\\$user['role'] === 'admin') {",
      "            redirect('admin.php');",
      "        } else {",
      "            redirect('index.php');",
      "        }",
      "    } else {",
      "        \\$error = 'Неверный логин или пароль';",
      "    }",
      "}",
      "?>",
      "<!DOCTYPE html>",
      "<html lang='ru'>",
      "<head>",
      "    <meta charset='UTF-8'>",
      "    <meta name='viewport' content='width=device-width, initial-scale=1'>",
      "    <title>Авторизация</title>",
      "    <link href='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css' rel='stylesheet'>",
      "    <style>",
      "        body { background: linear-gradient(135deg, #667eea 0%, #764ba2 100%); min-height: 100vh; }",
      "        .card { animation: slideIn 0.5s ease; }",
      "        @keyframes slideIn { from { opacity: 0; transform: translateY(30px); } to { opacity: 1; transform: translateY(0); } }",
      "    </style>",
      "</head>",
      "<body>",
      "    <div class='container mt-5'>",
      "        <div class='row justify-content-center'>",
      "            <div class='col-md-5'>",
      "                <div class='card shadow'>",
      "                    <div class='card-header bg-success text-white text-center'>",
      "                        <h3>Вход в систему</h3>",
      "                    </div>",
      "                    <div class='card-body'>",
      "                        <?php if (\\$error): ?>",
      "                            <div class='alert alert-danger'><?php echo \\$error; ?></div>",
      "                        <?php endif; ?>",
      "                        <?php if (isset(\\$_SESSION['message'])): ?>",
      "                            <div class='alert alert-success'><?php echo \\$_SESSION['message']; unset(\\$_SESSION['message']); ?></div>",
      "                        <?php endif; ?>",
      "                        <form method='POST'>",
      "                            <div class='mb-3'>",
      "                                <label>Логин или Email</label>",
      "                                <input type='text' name='login' class='form-control' required autofocus>",
      "                            </div>",
      "                            <div class='mb-3'>",
      "                                <label>Пароль</label>",
      "                                <input type='password' name='password' class='form-control' required>",
      "                            </div>",
      "                            <button type='submit' class='btn btn-success w-100'>Войти</button>",
      "                        </form>",
      "                        <div class='text-center mt-3'>",
      "                            <a href='register.php'>Нет аккаунта? Зарегистрируйтесь</a>",
      "                        </div>",
      "                    </div>",
      "                </div>",
      "            </div>",
      "        </div>",
      "    </div>",
      "    <script src='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js'></script>",
      "</body>",
      "</html>"
    ],
    "description": "Страница авторизации с сообщениями об ошибках"
  },

  "═════ 5. КАТАЛОГ [STORE] (с фильтрами и анимацией) ═════": {
    "prefix": "catalog-skeleton",
    "body": [
      "<?php",
      "require_once 'config.php';",
      "",
      "// Фильтрация",
      "\\$where = 'WHERE is_active = 1';",
      "\\$params = [];",
      "",
      "if (isset(\\$_GET['category']) && !empty(\\$_GET['category'])) {",
      "    \\$where .= ' AND category = ?';",
      "    \\$params[] = \\$_GET['category'];",
      "}",
      "",
      "if (isset(\\$_GET['search']) && !empty(\\$_GET['search'])) {",
      "    \\$where .= ' AND name LIKE ?';",
      "    \\$params[] = '%' . \\$_GET['search'] . '%';",
      "}",
      "",
      "\\$stmt = \\$pdo->prepare('SELECT * FROM items ' . \\$where . ' ORDER BY id DESC');",
      "\\$stmt->execute(\\$params);",
      "\\$items = \\$stmt->fetchAll();",
      "",
      "// Получение категорий для фильтра",
      "\\$categories = \\$pdo->query('SELECT DISTINCT category FROM items WHERE category IS NOT NULL')->fetchAll();",
      "?>",
      "<!DOCTYPE html>",
      "<html lang='ru'>",
      "<head>",
      "    <meta charset='UTF-8'>",
      "    <meta name='viewport' content='width=device-width, initial-scale=1'>",
      "    <title>Каталог товаров</title>",
      "    <link href='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css' rel='stylesheet'>",
      "    <link rel='stylesheet' href='https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css'>",
      "    <style>",
      "        .navbar { background: #2c3e50 !important; }",
      "        .card { transition: transform 0.3s, box-shadow 0.3s; margin-bottom: 20px; }",
      "        .card:hover { transform: translateY(-10px); box-shadow: 0 10px 20px rgba(0,0,0,0.2); }",
      "        .card-img-top { height: 200px; object-fit: cover; }",
      "        .cart-badge { position: fixed; bottom: 20px; right: 20px; z-index: 1000; }",
      "        .fade-in { animation: fadeIn 0.5s ease; }",
      "        @keyframes fadeIn { from { opacity: 0; } to { opacity: 1; } }",
      "        .price { font-size: 1.5rem; color: #e67e22; font-weight: bold; }",
      "    </style>",
      "</head>",
      "<body>",
      "    <nav class='navbar navbar-expand-lg navbar-dark'>",
      "        <div class='container'>",
      "            <a class='navbar-brand' href='index.php'><i class='fas fa-store'></i> Мой Магазин</a>",
      "            <div class='navbar-nav ms-auto'>",
      "                <?php if (isLoggedIn()): ?>",
      "                    <span class='nav-link text-light'>Привет, <?php echo htmlspecialchars(\\$_SESSION['full_name']); ?>!</span>",
      "                    <a class='nav-link' href='cart.php'><i class='fas fa-shopping-cart'></i> Корзина</a>",
      "                    <a class='nav-link' href='orders.php'>Мои заказы</a>",
      "                    <?php if (isAdmin()): ?>",
      "                        <a class='nav-link text-warning' href='admin.php'><i class='fas fa-user-shield'></i> Админ</a>",
      "                    <?php endif; ?>",
      "                    <a class='nav-link' href='logout.php'>Выход</a>",
      "                <?php else: ?>",
      "                    <a class='nav-link' href='login.php'>Вход</a>",
      "                    <a class='nav-link' href='register.php'>Регистрация</a>",
      "                <?php endif; ?>",
      "            </div>",
      "        </div>",
      "    </nav>",
      "",
      "    <div class='container mt-4'>",
      "        <div class='row'>",
      "            <!-- Sidebar с фильтрами -->",
      "            <div class='col-md-3'>",
      "                <div class='card'>",
      "                    <div class='card-header bg-primary text-white'>",
      "                        <h5><i class='fas fa-filter'></i> Фильтры</h5>",
      "                    </div>",
      "                    <div class='card-body'>",
      "                        <form method='GET'>",
      "                            <div class='mb-3'>",
      "                                <label>Поиск</label>",
      "                                <input type='text' name='search' class='form-control' placeholder='Название...' value='<?php echo \\$_GET['search'] ?? ''; ?>'>",
      "                            </div>",
      "                            <div class='mb-3'>",
      "                                <label>Категория</label>",
      "                                <select name='category' class='form-select'>",
      "                                    <option value=''>Все</option>",
      "                                    <?php foreach (\\$categories as \\$cat): ?>",
      "                                        <option value='<?php echo \\$cat['category']; ?>' <?php echo (isset(\\$_GET['category']) && \\$_GET['category'] == \\$cat['category']) ? 'selected' : ''; ?>>",
      "                                            <?php echo \\$cat['category']; ?>",
      "                                        </option>",
      "                                    <?php endforeach; ?>",
      "                                </select>",
      "                            </div>",
      "                            <button type='submit' class='btn btn-primary w-100'><i class='fas fa-search'></i> Применить</button>",
      "                        </form>",
      "                    </div>",
      "                </div>",
      "            </div>",
      "",
      "            <!-- Каталог товаров -->",
      "            <div class='col-md-9'>",
      "                <h1 class='mb-4 fade-in'>Наш каталог</h1>",
      "                <div class='row'>",
      "                    <?php if (empty(\\$items)): ?>",
      "                        <div class='alert alert-info'>Товары не найдены</div>",
      "                    <?php else: ?>",
      "                        <?php foreach (\\$items as \\$item): ?>",
      "                            <div class='col-md-4 fade-in'>",
      "                                <div class='card h-100'>",
      "                                    <img src='images/<?php echo \\$item['image'] ?? 'placeholder.jpg'; ?>' class='card-img-top' alt='<?php echo \\$item['name']; ?>'>",
      "                                    <div class='card-body'>",
      "                                        <h5 class='card-title'><?php echo htmlspecialchars(\\$item['name']); ?></h5>",
      "                                        <p class='card-text'><?php echo mb_substr(htmlspecialchars(\\$item['description']), 0, 100); ?>...</p>",
      "                                        <p class='price'><?php echo number_format(\\$item['price'], 2); ?> ₽</p>",
      "                                        <p class='text-muted'>В наличии: <?php echo \\$item['stock']; ?></p>",
      "                                        <?php if (isLoggedIn()): ?>",
      "                                            <form action='add_to_cart.php' method='POST'>",
      "                                                <input type='hidden' name='item_id' value='<?php echo \\$item['id']; ?>'>",
      "                                                <div class='input-group'>",
      "                                                    <input type='number' name='quantity' value='1' min='1' max='<?php echo \\$item['stock']; ?>' class='form-control' style='width: 70px;'>",
      "                                                    <button type='submit' class='btn btn-primary'><i class='fas fa-cart-plus'></i> В корзину</button>",
      "                                                </div>",
      "                                            </form>",
      "                                        <?php else: ?>",
      "                                            <a href='login.php' class='btn btn-secondary'>Войдите для покупки</a>",
      "                                        <?php endif; ?>",
      "                                    </div>",
      "                                </div>",
      "                            </div>",
      "                        <?php endforeach; ?>",
      "                    <?php endif; ?>",
      "                </div>",
      "            </div>",
      "        </div>",
      "    </div>",
      "",
      "    <script src='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js'></script>",
      "</body>",
      "</html>"
    ],
    "description": "[STORE] Каталог с фильтрацией по категориям и поиском"
  },

  "═════ 6. КОРЗИНА [STORE] ═════": {
    "prefix": "cart-skeleton",
    "body": [
      "<?php",
      "require_once 'config.php';",
      "",
      "if (!isLoggedIn()) {",
      "    redirect('login.php');",
      "}",
      "",
      "// Инициализация корзины в сессии",
      "if (!isset(\\$_SESSION['cart'])) {",
      "    \\$_SESSION['cart'] = [];",
      "}",
      "",
      "// Добавление в корзину",
      "if (isset(\\$_POST['add_to_cart'])) {",
      "    \\$item_id = \\$_POST['item_id'];",
      "    \\$quantity = (int)\\$_POST['quantity'];",
      "",
      "    if (isset(\\$_SESSION['cart'][\\$item_id])) {",
      "        \\$_SESSION['cart'][\\$item_id] += \\$quantity;",
      "    } else {",
      "        \\$_SESSION['cart'][\\$item_id] = \\$quantity;",
      "    }",
      "    redirect('cart.php');",
      "}",
      "",
      "// Обновление корзины",
      "if (isset(\\$_POST['update_cart'])) {",
      "    foreach (\\$_POST['quantity'] as \\$id => \\$qty) {",
      "        if (\\$qty <= 0) {",
      "            unset(\\$_SESSION['cart'][\\$id]);",
      "        } else {",
      "            \\$_SESSION['cart'][\\$id'] = (int)\\$qty;",
      "        }",
      "    }",
      "    redirect('cart.php');",
      "}",
      "",
      "// Удаление из корзины",
      "if (isset(\\$_GET['remove'])) {",
      "    unset(\\$_SESSION['cart'][\\$_GET['remove']]);",
      "    redirect('cart.php');",
      "}",
      "",
      "// Получение данных о товарах в корзине",
      "\\$cart_items = [];",
      "\\$total = 0;",
      "",
      "if (!empty(\\$_SESSION['cart'])) {",
      "    \\$ids = array_keys(\\$_SESSION['cart']);",
      "    \\$placeholders = implode(',', array_fill(0, count(\\$ids), '?'));",
      "    \\$stmt = \\$pdo->prepare('SELECT * FROM items WHERE id IN (' . \\$placeholders . ')');",
      "    \\$stmt->execute(\\$ids);",
      "    \\$products = \\$stmt->fetchAll();",
      "",
      "    foreach (\\$products as \\$product) {",
      "        \\$qty = \\$_SESSION['cart'][\\$product['id']];",
      "        \\$subtotal = \\$product['price'] * \\$qty;",
      "        \\$cart_items[] = [",
      "            'product' => \\$product,",
      "            'quantity' => \\$qty,",
      "            'subtotal' => \\$subtotal",
      "        ];",
      "        \\$total += \\$subtotal;",
      "    }",
      "}",
      "?>",
      "<!DOCTYPE html>",
      "<html lang='ru'>",
      "<head>",
      "    <meta charset='UTF-8'>",
      "    <meta name='viewport' content='width=device-width, initial-scale=1'>",
      "    <title>Корзина</title>",
      "    <link href='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css' rel='stylesheet'>",
      "    <link rel='stylesheet' href='https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css'>",
      "    <style>",
      "        .table img { width: 80px; height: 80px; object-fit: cover; }",
      "        .quantity-input { width: 80px; text-align: center; }",
      "        .total { font-size: 1.5rem; font-weight: bold; }",
      "        .checkout-btn { background: #28a745; color: white; padding: 12px 30px; font-size: 1.2rem; }",
      "    </style>",
      "</head>",
      "<body>",
      "    <div class='container mt-4'>",
      "        <h1><i class='fas fa-shopping-cart'></i> Моя корзина</h1>",
      "        <a href='catalog.php' class='btn btn-secondary mb-3'><i class='fas fa-arrow-left'></i> Продолжить покупки</a>",
      "",
      "        <?php if (empty(\\$cart_items)): ?>",
      "            <div class='alert alert-info'>Корзина пуста</div>",
      "        <?php else: ?>",
      "            <form method='POST'>",
      "                <div class='table-responsive'>",
      "                    <table class='table table-bordered'>",
      "                        <thead class='table-dark'>",
      "                            <tr><th>Товар</th><th>Цена</th><th>Кол-во</th><th>Сумма</th><th></th></tr>",
      "                        </thead>",
      "                        <tbody>",
      "                            <?php foreach (\\$cart_items as \\$item): ?>",
      "                                <tr>",
      "                                    <td>",
      "                                        <img src='images/<?php echo \\$item['product']['image'] ?? 'placeholder.jpg'; ?>' alt=''>",
      "                                        <?php echo htmlspecialchars(\\$item['product']['name']); ?>",
      "                                    </td>",
      "                                    <td><?php echo number_format(\\$item['product']['price'], 2); ?> ₽</td>",
      "                                    <td><input type='number' name='quantity[<?php echo \\$item['product']['id']; ?>]' value='<?php echo \\$item['quantity']; ?>' min='0' class='form-control quantity-input'></td>",
      "                                    <td><?php echo number_format(\\$item['subtotal'], 2); ?> ₽</td>",
      "                                    <td><a href='?remove=<?php echo \\$item['product']['id']; ?>' class='btn btn-sm btn-danger'><i class='fas fa-trash'></i></a></td>",
      "                                </tr>",
      "                            <?php endforeach; ?>",
      "                            <tr class='table-info'>",
      "                                <td colspan='3' class='text-end'><strong>Итого:</strong></td>",
      "                                <td colspan='2'><span class='total'><?php echo number_format(\\$total, 2); ?> ₽</span></td>",
      "                            </tr>",
      "                        </tbody>",
      "                    </table>",
      "                </div>",
      "                <button type='submit' name='update_cart' class='btn btn-warning'><i class='fas fa-sync-alt'></i> Обновить корзину</button>",
      "                <a href='checkout.php' class='btn checkout-btn float-end'><i class='fas fa-check-circle'></i> Оформить заказ</a>",
      "            </form>",
      "        <?php endif; ?>",
      "    </div>",
      "    <script src='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js'></script>",
      "</body>",
      "</html>"
    ],
    "description": "[STORE] Корзина с количеством и удалением"
  },

  "═════ 7. ОФОРМЛЕНИЕ ЗАКАЗА [STORE] ═════": {
    "prefix": "checkout-skeleton",
    "body": [
      "<?php",
      "require_once 'config.php';",
      "",
      "if (!isLoggedIn()) {",
      "    redirect('login.php');",
      "}",
      "",
      "if (empty(\\$_SESSION['cart'])) {",
      "    redirect('catalog.php');",
      "}",
      "",
      "if (\\$_SERVER['REQUEST_METHOD'] === 'POST') {",
      "    \\$address = trim(\\$_POST['address']);",
      "    \\$delivery_time = \\$_POST['delivery_time'] ?? null;",
      "    \\$payment_method = \\$_POST['payment_method'] ?? 'cash';",
      "    \\$notes = trim(\\$_POST['notes'] ?? '');",
      "",
      "    // Расчет общей суммы",
      "    \\$total = 0;",
      "    \\$items_data = [];",
      "    \\$ids = array_keys(\\$_SESSION['cart']);",
      "    \\$placeholders = implode(',', array_fill(0, count(\\$ids), '?'));",
      "    \\$stmt = \\$pdo->prepare('SELECT * FROM items WHERE id IN (' . \\$placeholders . ')');",
      "    \\$stmt->execute(\\$ids);",
      "    \\$products = \\$stmt->fetchAll();",
      "",
      "    foreach (\\$products as \\$product) {",
      "        \\$qty = \\$_SESSION['cart'][\\$product['id']];",
      "        \\$subtotal = \\$product['price'] * \\$qty;",
      "        \\$total += \\$subtotal;",
      "        \\$items_data[] = [",
      "            'id' => \\$product['id'],",
      "            'quantity' => \\$qty,",
      "            'price' => \\$product['price']",
      "        ];",
      "    }",
      "",
      "    // Сохранение заказа",
      "    \\$pdo->beginTransaction();",
      "    try {",
      "        \\$stmt = \\$pdo->prepare('INSERT INTO orders (user_id, total_amount, status, delivery_address, delivery_time, payment_method, notes) VALUES (?, ?, ?, ?, ?, ?, ?)');",
      "        \\$stmt->execute([\\$_SESSION['user_id'], \\$total, 'new', \\$address, \\$delivery_time, \\$payment_method, \\$notes]);",
      "        \\$order_id = \\$pdo->lastInsertId();",
      "",
      "        foreach (\\$items_data as \\$item) {",
      "            \\$stmt = \\$pdo->prepare('INSERT INTO order_items (order_id, item_id, quantity, price) VALUES (?, ?, ?, ?)');",
      "            \\$stmt->execute([\\$order_id, \\$item['id'], \\$item['quantity'], \\$item['price']]);",
      "",
      "            // Уменьшение остатка на складе",
      "            \\$pdo->prepare('UPDATE items SET stock = stock - ? WHERE id = ?')->execute([\\$item['quantity'], \\$item['id']]);",
      "        }",
      "",
      "        \\$pdo->commit();",
      "        \\$_SESSION['cart'] = [];",
      "        \\$_SESSION['message'] = 'Заказ №' . \\$order_id . ' успешно оформлен!';",
      "        redirect('orders.php');",
      "    } catch (Exception \\$e) {",
      "        \\$pdo->rollBack();",
      "        \\$error = 'Ошибка при оформлении заказа: ' . \\$e->getMessage();",
      "    }",
      "}",
      "?>",
      "<!DOCTYPE html>",
      "<html lang='ru'>",
      "<head>",
      "    <meta charset='UTF-8'>",
      "    <meta name='viewport' content='width=device-width, initial-scale=1'>",
      "    <title>Оформление заказа</title>",
      "    <link href='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css' rel='stylesheet'>",
      "    <link rel='stylesheet' href='https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css'>",
      "</head>",
      "<body>",
      "    <div class='container mt-4'>",
      "        <h1><i class='fas fa-clipboard-list'></i> Оформление заказа</h1>",
      "        <div class='row'>",
      "            <div class='col-md-6'>",
      "                <div class='card'>",
      "                    <div class='card-header bg-primary text-white'>",
      "                        <h5>Данные для доставки</h5>",
      "                    </div>",
      "                    <div class='card-body'>",
      "                        <?php if (isset(\\$error)): ?>",
      "                            <div class='alert alert-danger'><?php echo \\$error; ?></div>",
      "                        <?php endif; ?>",
      "                        <form method='POST'>",
      "                            <div class='mb-3'>",
      "                                <label>Адрес доставки *</label>",
      "                                <textarea name='address' class='form-control' rows='3' required></textarea>",
      "                            </div>",
      "                            <div class='mb-3'>",
      "                                <label>Желаемое время доставки</label>",
      "                                <input type='text' name='delivery_time' class='form-control' placeholder='например, 09:00-18:00'>",
      "                            </div>",
      "                            <div class='mb-3'>",
      "                                <label>Способ оплаты *</label>",
      "                                <select name='payment_method' class='form-select'>",
      "                                    <option value='cash'>Наличными при получении</option>",
      "                                    <option value='card'>Картой при получении</option>",
      "                                    <option value='online'>Онлайн</option>",
      "                                </select>",
      "                            </div>",
      "                            <div class='mb-3'>",
      "                                <label>Комментарий к заказу</label>",
      "                                <textarea name='notes' class='form-control' rows='2'></textarea>",
      "                            </div>",
      "                            <button type='submit' class='btn btn-success'><i class='fas fa-check'></i> Подтвердить заказ</button>",
      "                            <a href='cart.php' class='btn btn-secondary'>Назад к корзине</a>",
      "                        </form>",
      "                    </div>",
      "                </div>",
      "            </div>",
      "        </div>",
      "    </div>",
      "    <script src='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js'></script>",
      "</body>",
      "</html>"
    ],
    "description": "[STORE] Оформление заказа с адресом и оплатой"
  },

  "═════ 8. ПАНЕЛЬ АДМИНИСТРАТОРА [STORE] ═════": {
    "prefix": "admin-skeleton",
    "body": [
      "<?php",
      "require_once 'config.php';",
      "",
      "if (!isAdmin()) {",
      "    redirect('login.php');",
      "}",
      "",
      "// ========== УПРАВЛЕНИЕ ЗАКАЗАМИ ==========",
      "if (isset(\\$_GET['change_status']) && isset(\\$_GET['status'])) {",
      "    \\$stmt = \\$pdo->prepare('UPDATE orders SET status = ? WHERE id = ?');",
      "    \\$stmt->execute([\\$_GET['status'], \\$_GET['change_status']]);",
      "    redirect('admin.php');",
      "}",
      "",
      "// ========== УПРАВЛЕНИЕ ТОВАРАМИ ==========",
      "// Добавление товара",
      "if (isset(\\$_POST['add_product'])) {",
      "    \\$name = \\$_POST['name'];",
      "    \\$description = \\$_POST['description'];",
      "    \\$price = \\$_POST['price'];",
      "    \\$stock = \\$_POST['stock'];",
      "    \\$category = \\$_POST['category'];",
      "    ",
      "    \\$image_name = null;",
      "    if (isset(\\$_FILES['image']) && \\$_FILES['image']['error'] == 0) {",
      "        \\$image_name = time() . '_' . \\$_FILES['image']['name'];",
      "        \\$upload_dir = 'images/';",
      "        if (!is_dir(\\$upload_dir)) mkdir(\\$upload_dir, 0777, true);",
      "        move_uploaded_file(\\$_FILES['image']['tmp_name'], \\$upload_dir . \\$image_name);",
      "    }",
      "    ",
      "    \\$stmt = \\$pdo->prepare('INSERT INTO items (name, description, price, stock, category, image) VALUES (?, ?, ?, ?, ?, ?)');",
      "    \\$stmt->execute([\\$name, \\$description, \\$price, \\$stock, \\$category, \\$image_name]);",
      "    \\$_SESSION['message'] = 'Товар добавлен!';",
      "    redirect('admin.php');",
      "}",
      "",
      "// Удаление товара",
      "if (isset(\\$_GET['delete_item'])) {",
      "    \\$stmt = \\$pdo->prepare('DELETE FROM items WHERE id = ?');",
      "    \\$stmt->execute([\\$_GET['delete_item']]);",
      "    \\$_SESSION['message'] = 'Товар удален!';",
      "    redirect('admin.php');",
      "}",
      "",
      "// Редактирование товара",
      "if (isset(\\$_POST['edit_product'])) {",
      "    \\$stmt = \\$pdo->prepare('UPDATE items SET name=?, description=?, price=?, stock=?, category=? WHERE id=?');",
      "    \\$stmt->execute([\\$_POST['name'], \\$_POST['description'], \\$_POST['price'], \\$_POST['stock'], \\$_POST['category'], \\$_POST['item_id']]);",
      "    \\$_SESSION['message'] = 'Товар обновлен!';",
      "    redirect('admin.php');",
      "}",
      "",
      "// ========== ПОЛУЧЕНИЕ ДАННЫХ ==========",
      "// Все заказы (всех пользователей)",
      "\\$stmt = \\$pdo->query('",
      "    SELECT o.*, u.full_name, u.email, u.phone ",
      "    FROM orders o ",
      "    JOIN users u ON o.user_id = u.id ",
      "    ORDER BY o.created_at DESC",
      "');",
      "\\$orders = \\$stmt->fetchAll();",
      "",
      "// Все товары",
      "\\$items = \\$pdo->query('SELECT * FROM items ORDER BY id DESC')->fetchAll();",
      "",
      "// Статистика",
      "\\$total_orders = \\$pdo->query('SELECT COUNT(*) FROM orders')->fetchColumn();",
      "\\$total_amount = \\$pdo->query('SELECT SUM(total_amount) FROM orders')->fetchColumn();",
      "\\$total_items = \\$pdo->query('SELECT COUNT(*) FROM items')->fetchColumn();",
      "\\$low_stock = \\$pdo->query('SELECT COUNT(*) FROM items WHERE stock < 5')->fetchColumn();",
      "",
      "\\$active_tab = \\$_GET['tab'] ?? 'orders';",
      "?>",
      "<!DOCTYPE html>",
      "<html lang='ru'>",
      "<head>",
      "    <meta charset='UTF-8'>",
      "    <meta name='viewport' content='width=device-width, initial-scale=1'>",
      "    <title>Панель администратора</title>",
      "    <link href='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css' rel='stylesheet'>",
      "    <link rel='stylesheet' href='https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css'>",
      "    <style>",
      "        .sidebar { background: #2c3e50; min-height: 100vh; }",
      "        .sidebar a { color: white; text-decoration: none; padding: 12px 20px; display: block; transition: 0.3s; }",
      "        .sidebar a:hover, .sidebar a.active { background: #1abc9c; }",
      "        .status-badge { padding: 5px 12px; border-radius: 20px; font-size: 0.75rem; font-weight: bold; }",
      "        .status-new { background: #17a2b8; color: white; }",
      "        .status-confirmed { background: #007bff; color: white; }",
      "        .status-processing { background: #ffc107; color: black; }",
      "        .status-completed { background: #28a745; color: white; }",
      "        .status-cancelled { background: #dc3545; color: white; }",
      "        .stat-card { transition: transform 0.3s; }",
      "        .stat-card:hover { transform: translateY(-5px); }",
      "        .product-img { width: 50px; height: 50px; object-fit: cover; border-radius: 5px; }",
      "    </style>",
      "</head>",
      "<body>",
      "    <div class='container-fluid'>",
      "        <div class='row'>",
      "            <!-- БОКОВАЯ ПАНЕЛЬ -->",
      "            <div class='col-md-2 sidebar p-0'>",
      "                <div class='text-center py-4 bg-dark'>",
      "                    <h4 class='text-white'><i class='fas fa-user-shield'></i> Админ</h4>",
      "                </div>",
      "                <a href='?tab=orders' class='<?php echo \\$active_tab == 'orders' ? 'active' : ''; ?>'>",
      "                    <i class='fas fa-shopping-cart'></i> Заказы",
      "                </a>",
      "                <a href='?tab=products' class='<?php echo \\$active_tab == 'products' ? 'active' : ''; ?>'>",
      "                    <i class='fas fa-boxes'></i> Товары",
      "                </a>",
      "                <a href='?tab=add' class='<?php echo \\$active_tab == 'add' ? 'active' : ''; ?>'>",
      "                    <i class='fas fa-plus-circle'></i> Добавить товар",
      "                </a>",
      "                <hr class='bg-light'>",
      "                <a href='logout.php' class='text-danger'><i class='fas fa-sign-out-alt'></i> Выход</a>",
      "            </div>",
      "",
      "            <!-- ОСНОВНОЕ СОДЕРЖИМОЕ -->",
      "            <div class='col-md-10 p-4'>",
      "                <?php if (isset(\\$_SESSION['message'])): ?>",
      "                    <div class='alert alert-success alert-dismissible fade show'>",
      "                        <?php echo \\$_SESSION['message']; unset(\\$_SESSION['message']); ?>",
      "                        <button type='button' class='btn-close' data-bs-dismiss='alert'></button>",
      "                    </div>",
      "                <?php endif; ?>",
      "",
      "                <!-- СТАТИСТИКА (видны всегда) -->",
      "                <div class='row mb-4'>",
      "                    <div class='col-md-3'>",
      "                        <div class='card stat-card text-white bg-primary'>",
      "                            <div class='card-body'>",
      "                                <h5>Всего заказов</h5>",
      "                                <h2><?php echo \\$total_orders; ?></h2>",
      "                            </div>",
      "                        </div>",
      "                    </div>",
      "                    <div class='col-md-3'>",
      "                        <div class='card stat-card text-white bg-success'>",
      "                            <div class='card-body'>",
      "                                <h5>Выручка</h5>",
      "                                <h2><?php echo number_format(\\$total_amount, 0); ?> ₽</h2>",
      "                            </div>",
      "                        </div>",
      "                    </div>",
      "                    <div class='col-md-3'>",
      "                        <div class='card stat-card text-white bg-info'>",
      "                            <div class='card-body'>",
      "                                <h5>Товаров</h5>",
      "                                <h2><?php echo \\$total_items; ?></h2>",
      "                            </div>",
      "                        </div>",
      "                    </div>",
      "                    <div class='col-md-3'>",
      "                        <div class='card stat-card text-white bg-warning'>",
      "                            <div class='card-body'>",
      "                                <h5>Товаров < 5 шт</h5>",
      "                                <h2><?php echo \\$low_stock; ?></h2>",
      "                            </div>",
      "                        </div>",
      "                    </div>",
      "                </div>",
      "",
      "                <!-- ВКЛАДКА: ЗАКАЗЫ -->",
      "                <?php if (\\$active_tab == 'orders'): ?>",
      "                <div class='card'>",
      "                    <div class='card-header bg-dark text-white'>",
      "                        <h5><i class='fas fa-list'></i> Все заказы клиентов</h5>",
      "                    </div>",
      "                    <div class='card-body'>",
      "                        <div class='table-responsive'>",
      "                            <table class='table table-striped'>",
      "                                <thead>",
      "                                    <tr><th>№</th><th>Клиент</th><th>Контакты</th><th>Сумма</th><th>Статус</th><th>Дата</th><th>Действия</th></tr>",
      "                                </thead>",
      "                                <tbody>",
      "                                    <?php foreach (\\$orders as \\$order): ?>",
      "                                        <tr>",
      "                                            <td><?php echo \\$order['id']; ?></td>",
      "                                            <td><?php echo htmlspecialchars(\\$order['full_name']); ?></td>",
      "                                            <td><?php echo \\$order['email']; ?><br><small><?php echo \\$order['phone']; ?></small></td>",
      "                                            <td><?php echo number_format(\\$order['total_amount'], 2); ?> ₽</td>",
      "                                            <td><span class='status-badge status-<?php echo \\$order['status']; ?>'>",
      "                                                <?php \\$statuses = ['new'=>'Новый','confirmed'=>'Подтвержден','processing'=>'В обработке','completed'=>'Выполнен','cancelled'=>'Отменен']; echo \\$statuses[\\$order['status']]; ?>",
      "                                            </span></td>",
      "                                            <td><?php echo date('d.m.Y H:i', strtotime(\\$order['created_at'])); ?></td>",
      "                                            <td>",
      "                                                <div class='btn-group btn-group-sm'>",
      "                                                    <a href='?change_status=<?php echo \\$order['id']; ?>&status=confirmed' class='btn btn-primary'>Подтвердить</a>",
      "                                                    <a href='?change_status=<?php echo \\$order['id']; ?>&status=processing' class='btn btn-warning'>В работу</a>",
      "                                                    <a href='?change_status=<?php echo \\$order['id']; ?>&status=completed' class='btn btn-success'>Завершить</a>",
      "                                                    <a href='?change_status=<?php echo \\$order['id']; ?>&status=cancelled' class='btn btn-danger'>Отменить</a>",
      "                                                </div>",
      "                                            </td>",
      "                                        </tr>",
      "                                    <?php endforeach; ?>",
      "                                </tbody>",
      "                            </table>",
      "                        </div>",
      "                    </div>",
      "                </div>",
      "                <?php endif; ?>",
      "",
      "                <!-- ВКЛАДКА: ТОВАРЫ (СПИСОК) -->",
      "                <?php if (\\$active_tab == 'products'): ?>",
      "                <div class='card'>",
      "                    <div class='card-header bg-dark text-white d-flex justify-content-between'>",
      "                        <h5><i class='fas fa-boxes'></i> Управление товарами</h5>",
      "                        <a href='?tab=add' class='btn btn-sm btn-success'>+ Добавить товар</a>",
      "                    </div>",
      "                    <div class='card-body'>",
      "                        <div class='table-responsive'>",
      "                            <table class='table table-striped'>",
      "                                <thead>",
      "                                    <tr><th>ID</th><th>Изобр.</th><th>Название</th><th>Категория</th><th>Цена</th><th>Остаток</th><th>Действия</th></tr>",
      "                                </thead>",
      "                                <tbody>",
      "                                    <?php foreach (\\$items as \\$item): ?>",
      "                                        <tr>",
      "                                            <td><?php echo \\$item['id']; ?></td>",
      "                                            <td><img src='images/<?php echo \\$item['image'] ?? 'placeholder.jpg'; ?>' class='product-img'>\n                                            </td>",
      "                                            <td><?php echo htmlspecialchars(\\$item['name']); ?></td>",
      "                                            <td><?php echo \\$item['category'] ?? '-'; ?></td>",
      "                                            <td><?php echo number_format(\\$item['price'], 2); ?> ₽</td>",
      "                                            <td>",
      "                                                <?php if (\\$item['stock'] < 5): ?>",
      "                                                    <span class='text-danger'><strong><?php echo \\$item['stock']; ?></strong></span>",
      "                                                <?php else: ?>",
      "                                                    <?php echo \\$item['stock']; ?>",
      "                                                <?php endif; ?>",
      "                                              </div>",
      "                                            </td>",
      "                                            <td>",
      "                                                <button class='btn btn-sm btn-warning' data-bs-toggle='modal' data-bs-target='#editModal'",
      "                                                        data-id='<?php echo \\$item['id']; ?>'",
      "                                                        data-name='<?php echo htmlspecialchars(\\$item['name']); ?>'",
      "                                                        data-desc='<?php echo htmlspecialchars(\\$item['description']); ?>'",
      "                                                        data-price='<?php echo \\$item['price']; ?>'",
      "                                                        data-stock='<?php echo \\$item['stock']; ?>'",
      "                                                        data-cat='<?php echo \\$item['category']; ?>'>",
      "                                                    <i class='fas fa-edit'></i>",
      "                                                </button>",
      "                                                <a href='?delete_item=<?php echo \\$item['id']; ?>' class='btn btn-sm btn-danger' onclick='return confirm(\"Удалить товар?\")'>",
      "                                                    <i class='fas fa-trash'></i>",
      "                                                </a>",
      "                                              </div>",
      "                                            </td>",
      "                                        </tr>",
      "                                    <?php endforeach; ?>",
      "                                </tbody>",
      "                            </table>",
      "                        </div>",
      "                    </div>",
      "                </div>",
      "                <?php endif; ?>",
      "",
      "                <!-- ВКЛАДКА: ДОБАВЛЕНИЕ ТОВАРА -->",
      "                <?php if (\\$active_tab == 'add'): ?>",
      "                <div class='card'>",
      "                    <div class='card-header bg-dark text-white'>",
      "                        <h5><i class='fas fa-plus'></i> Добавить новый товар</h5>",
      "                    </div>",
      "                    <div class='card-body'>",
      "                        <form method='POST' enctype='multipart/form-data'>",
      "                            <div class='row'>",
      "                                <div class='col-md-6 mb-3'>",
      "                                    <label>Название товара *</label>",
      "                                    <input type='text' name='name' class='form-control' required>",
      "                                </div>",
      "                                <div class='col-md-6 mb-3'>",
      "                                    <label>Категория</label>",
      "                                    <input type='text' name='category' class='form-control'>",
      "                                </div>",
      "                                <div class='col-md-12 mb-3'>",
      "                                    <label>Описание</label>",
      "                                    <textarea name='description' class='form-control' rows='3'></textarea>",
      "                                </div>",
      "                                <div class='col-md-4 mb-3'>",
      "                                    <label>Цена (₽) *</label>",
      "                                    <input type='number' name='price' step='0.01' class='form-control' required>",
      "                                </div>",
      "                                <div class='col-md-4 mb-3'>",
      "                                    <label>Количество на складе</label>",
      "                                    <input type='number' name='stock' value='0' class='form-control'>",
      "                                </div>",
      "                                <div class='col-md-4 mb-3'>",
      "                                    <label>Изображение</label>",
      "                                    <input type='file' name='image' class='form-control' accept='image/*'>",
      "                                </div>",
      "                                <div class='col-12'>",
      "                                    <button type='submit' name='add_product' class='btn btn-success'><i class='fas fa-save'></i> Сохранить</button>",
      "                                    <a href='?tab=products' class='btn btn-secondary'>Отмена</a>",
      "                                </div>",
      "                            </div>",
      "                        </form>",
      "                    </div>",
      "                </div>",
      "                <?php endif; ?>",
      "            </div>",
      "        </div>",
      "    </div>",
      "",
      "    <!-- МОДАЛЬНОЕ ОКНО РЕДАКТИРОВАНИЯ -->",
      "    <div class='modal fade' id='editModal' tabindex='-1'>",
      "        <div class='modal-dialog'>",
      "            <div class='modal-content'>",
      "                <form method='POST'>",
      "                    <div class='modal-header bg-warning'>",
      "                        <h5 class='modal-title'><i class='fas fa-edit'></i> Редактировать товар</h5>",
      "                        <button type='button' class='btn-close' data-bs-dismiss='modal'></button>",
      "                    </div>",
      "                    <div class='modal-body'>",
      "                        <input type='hidden' name='item_id' id='edit_id'>",
      "                        <div class='mb-2'><label>Название</label><input type='text' name='name' id='edit_name' class='form-control' required></div>",
      "                        <div class='mb-2'><label>Описание</label><textarea name='description' id='edit_desc' class='form-control' rows='2'></textarea></div>",
      "                        <div class='mb-2'><label>Категория</label><input type='text' name='category' id='edit_cat' class='form-control'></div>",
      "                        <div class='row'>",
      "                            <div class='col-6'><label>Цена</label><input type='number' name='price' id='edit_price' step='0.01' class='form-control' required></div>",
      "                            <div class='col-6'><label>Остаток</label><input type='number' name='stock' id='edit_stock' class='form-control'></div>",
      "                        </div>",
      "                    </div>",
      "                    <div class='modal-footer'>",
      "                        <button type='button' class='btn btn-secondary' data-bs-dismiss='modal'>Отмена</button>",
      "                        <button type='submit' name='edit_product' class='btn btn-primary'>Сохранить изменения</button>",
      "                    </div>",
      "                </form>",
      "            </div>",
      "        </div>",
      "    </div>",
      "",
      "    <script src='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js'></script>",
      "    <script>",
      "        const editModal = document.getElementById('editModal');",
      "        editModal.addEventListener('show.bs.modal', function(event) {",
      "            const button = event.relatedTarget;",
      "            document.getElementById('edit_id').value = button.dataset.id;",
      "            document.getElementById('edit_name').value = button.dataset.name;",
      "            document.getElementById('edit_desc').value = button.dataset.desc || '';",
      "            document.getElementById('edit_price').value = button.dataset.price;",
      "            document.getElementById('edit_stock').value = button.dataset.stock;",
      "            document.getElementById('edit_cat').value = button.dataset.cat || '';",
      "        });",
      "    </script>",
      "</body>",
      "</html>"
    ],
    "description": "[STORE] ПОЛНАЯ админ-панель: заказы всех пользователей + управление товарами"
  },

  "═════ 9. СТРАНИЦА ЗАКАЗОВ ПОЛЬЗОВАТЕЛЯ [STORE] ═════": {
    "prefix": "orders-skeleton",
    "body": [
      "<?php",
      "require_once 'config.php';",
      "",
      "if (!isLoggedIn()) {",
      "    redirect('login.php');",
      "}",
      "",
      "\\$stmt = \\$pdo->prepare('SELECT * FROM orders WHERE user_id = ? ORDER BY created_at DESC');",
      "\\$stmt->execute([\\$_SESSION['user_id']]);",
      "\\$orders = \\$stmt->fetchAll();",
      "?>",
      "<!DOCTYPE html>",
      "<html lang='ru'>",
      "<head>",
      "    <meta charset='UTF-8'>",
      "    <meta name='viewport' content='width=device-width, initial-scale=1'>",
      "    <title>Мои заказы</title>",
      "    <link href='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css' rel='stylesheet'>",
      "    <link rel='stylesheet' href='https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css'>",
      "    <style>",
      "        .status-badge { padding: 5px 10px; border-radius: 20px; font-size: 0.8rem; }",
      "        .status-new { background: #17a2b8; color: white; }",
      "        .status-confirmed { background: #007bff; color: white; }",
      "        .status-processing { background: #ffc107; color: black; }",
      "        .status-completed { background: #28a745; color: white; }",
      "        .status-cancelled { background: #dc3545; color: white; }",
      "    </style>",
      "</head>",
      "<body>",
      "    <div class='container mt-4'>",
      "        <h1><i class='fas fa-box'></i> Мои заказы</h1>",
      "        <a href='catalog.php' class='btn btn-primary mb-3'><i class='fas fa-shopping-cart'></i> Новый заказ</a>",
      "",
      "        <?php if (isset(\\$_SESSION['message'])): ?>",
      "            <div class='alert alert-success'><?php echo \\$_SESSION['message']; unset(\\$_SESSION['message']); ?></div>",
      "        <?php endif; ?>",
      "",
      "        <?php if (empty(\\$orders)): ?>",
      "            <div class='alert alert-info'>У вас пока нет заказов</div>",
      "        <?php else: ?>",
      "            <div class='row'>",
      "                <?php foreach (\\$orders as \\$order): ?>",
      "                    <div class='col-md-6 mb-3'>",
      "                        <div class='card'>",
      "                            <div class='card-header d-flex justify-content-between'>",
      "                                <span><strong>Заказ №<?php echo \\$order['id']; ?></strong></span>",
      "                                <span class='status-badge status-<?php echo \\$order['status']; ?>'>",
      "                                    <?php",
      "                                        \\$statuses = ['new' => 'Новый', 'confirmed' => 'Подтвержден', 'processing' => 'В обработке', 'completed' => 'Завершен', 'cancelled' => 'Отменен'];",
      "                                        echo \\$statuses[\\$order['status']];",
      "                                    ?>",
      "                                </span>",
      "                            </div>",
      "                            <div class='card-body'>",
      "                                <p><strong>Сумма:</strong> <?php echo number_format(\\$order['total_amount'], 2); ?> ₽</p>",
      "                                <p><strong>Адрес:</strong> <?php echo htmlspecialchars(\\$order['delivery_address']); ?></p>",
      "                                <p><strong>Дата:</strong> <?php echo date('d.m.Y H:i', strtotime(\\$order['created_at'])); ?></p>",
      "                                <?php if (!empty(\\$order['notes'])): ?>",
      "                                    <p><strong>Комментарий:</strong> <?php echo htmlspecialchars(\\$order['notes']); ?></p>",
      "                                <?php endif; ?>",
      "                            </div>",
      "                        </div>",
      "                    </div>",
      "                <?php endforeach; ?>",
      "            </div>",
      "        <?php endif; ?>",
      "    </div>",
      "    <script src='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js'></script>",
      "</body>",
      "</html>"
    ],
    "description": "[STORE] Страница заказов пользователя"
  },

  "═════ 10. add_to_cart.php [STORE] ═════": {
    "prefix": "add-to-cart",
    "body": [
      "<?php",
      "require_once 'config.php';",
      "",
      "if (!isLoggedIn()) {",
      "    redirect('login.php');",
      "}",
      "",
      "if (!isset(\\$_SESSION['cart'])) {",
      "    \\$_SESSION['cart'] = [];",
      "}",
      "",
      "if (isset(\\$_POST['item_id'])) {",
      "    \\$item_id = (int)\\$_POST['item_id'];",
      "    \\$quantity = (int)(\\$_POST['quantity'] ?? 1);",
      "",
      "    if (isset(\\$_SESSION['cart'][\\$item_id])) {",
      "        \\$_SESSION['cart'][\\$item_id] += \\$quantity;",
      "    } else {",
      "        \\$_SESSION['cart'][\\$item_id] = \\$quantity;",
      "    }",
      "}",
      "",
      "redirect(\\$_SERVER['HTTP_REFERER'] ?? 'catalog.php');",
      "?>"
    ],
    "description": "[STORE] Обработчик добавления в корзину"
  },

  "═════ 11. logout.php ═════": {
    "prefix": "logout-skeleton",
    "body": [
      "<?php",
      "session_start();",
      "session_destroy();",
      "header('Location: login.php');",
      "exit();",
      "?>"
    ],
    "description": "Выход из системы"
  },

  "═════ 12. ГЛАВНАЯ СТРАНИЦА [STORE] ═════": {
    "prefix": "index-skeleton",
    "body": [
      "<?php",
      "require_once 'config.php';",
      "",
      "// Получение популярных товаров (по количеству заказов или просто последние 4)",
      "\\$stmt = \\$pdo->query('SELECT * FROM items WHERE is_active = 1 ORDER BY id DESC LIMIT 4');",
      "\\$popular_items = \\$stmt->fetchAll();",
      "",
      "// Получение категорий для навигации",
      "\\$categories = \\$pdo->query('SELECT DISTINCT category FROM items WHERE category IS NOT NULL LIMIT 6')->fetchAll();",
      "?>",
      "<!DOCTYPE html>",
      "<html lang='ru'>",
      "<head>",
      "    <meta charset='UTF-8'>",
      "    <meta name='viewport' content='width=device-width, initial-scale=1'>",
      "    <title><?php echo \\$site_name ?? 'Мой Магазин'; ?> - Главная</title>",
      "    <link href='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css' rel='stylesheet'>",
      "    <link rel='stylesheet' href='https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css'>",
      "    <style>",
      "        .hero { background: linear-gradient(135deg, #667eea 0%, #764ba2 100%); color: white; padding: 80px 0; text-align: center; }",
      "        .hero h1 { font-size: 3rem; animation: fadeInDown 0.8s ease; }",
      "        .hero p { font-size: 1.2rem; animation: fadeInUp 0.8s ease; }",
      "        .card { transition: transform 0.3s, box-shadow 0.3s; margin-bottom: 20px; }",
      "        .card:hover { transform: translateY(-10px); box-shadow: 0 10px 20px rgba(0,0,0,0.2); }",
      "        .card-img-top { height: 200px; object-fit: cover; }",
      "        .category-link { transition: all 0.3s; display: inline-block; margin: 5px; }",
      "        .category-link:hover { transform: scale(1.05); }",
      "        @keyframes fadeInDown { from { opacity: 0; transform: translateY(-30px); } to { opacity: 1; transform: translateY(0); } }",
      "        @keyframes fadeInUp { from { opacity: 0; transform: translateY(30px); } to { opacity: 1; transform: translateY(0); } }",
      "        .navbar { background: #2c3e50 !important; }",
      "        .search-box { max-width: 400px; margin: 20px auto; }",
      "        .price { font-size: 1.3rem; color: #e67e22; font-weight: bold; }",
      "    </style>",
      "</head>",
      "<body>",
      "    <!-- Navigation -->",
      "    <nav class='navbar navbar-expand-lg navbar-dark'>",
      "        <div class='container'>",
      "            <a class='navbar-brand' href='index.php'><i class='fas fa-store'></i> Мой Магазин</a>",
      "            <button class='navbar-toggler' type='button' data-bs-toggle='collapse' data-bs-target='#navbarNav'>",
      "                <span class='navbar-toggler-icon'></span>",
      "            </button>",
      "            <div class='collapse navbar-collapse' id='navbarNav'>",
      "                <ul class='navbar-nav me-auto'>",
      "                    <li class='nav-item'><a class='nav-link' href='index.php'>Главная</a></li>",
      "                    <li class='nav-item'><a class='nav-link' href='catalog.php'>Каталог</a></li>",
      "                    <?php if (isLoggedIn()): ?>",
      "                        <li class='nav-item'><a class='nav-link' href='cart.php'><i class='fas fa-shopping-cart'></i> Корзина</a></li>",
      "                        <li class='nav-item'><a class='nav-link' href='orders.php'>Мои заказы</a></li>",
      "                        <?php if (isAdmin()): ?>",
      "                            <li class='nav-item'><a class='nav-link text-warning' href='admin.php'><i class='fas fa-user-shield'></i> Админ</a></li>",
      "                        <?php endif; ?>",
      "                        <li class='nav-item'><a class='nav-link' href='logout.php'>Выход</a></li>",
      "                    <?php else: ?>",
      "                        <li class='nav-item'><a class='nav-link' href='login.php'>Вход</a></li>",
      "                        <li class='nav-item'><a class='nav-link' href='register.php'>Регистрация</a></li>",
      "                    <?php endif; ?>",
      "                </ul>",
      "                <form class='d-flex' action='catalog.php' method='GET'>",
      "                    <input class='form-control me-2' type='search' name='search' placeholder='Поиск...' aria-label='Search'>",
      "                    <button class='btn btn-outline-light' type='submit'><i class='fas fa-search'></i></button>",
      "                </form>",
      "            </div>",
      "        </div>",
      "    </nav>",
      "",
      "    <!-- Hero Section -->",
      "    <div class='hero'>",
      "        <div class='container'>",
      "            <h1><i class='fas fa-gem'></i> Добро пожаловать!</h1>",
      "            <p>Лучшие товары по лучшим ценам. Быстрая доставка и отличное качество.</p>",
      "            <a href='catalog.php' class='btn btn-light btn-lg mt-3'>Перейти в каталог →</a>",
      "        </div>",
      "    </div>",
      "",
      "    <div class='container mt-4'>",
      "        <!-- Поиск по сайту (быстрый) -->",
      "        <div class='search-box'>",
      "            <form action='catalog.php' method='GET' class='input-group'>",
      "                <input type='text' name='search' class='form-control' placeholder='Найти товар...'>",
      "                <button class='btn btn-primary' type='submit'><i class='fas fa-search'></i> Найти</button>",
      "            </form>",
      "        </div>",
      "",
      "        <!-- Разделы / Категории -->",
      "        <div class='text-center mb-4'>",
      "            <h3><i class='fas fa-tags'></i> Популярные категории</h3>",
      "            <div>",
      "                <?php foreach (\\$categories as \\$cat): ?>",
      "                    <a href='catalog.php?category=<?php echo urlencode(\\$cat['category']); ?>' class='btn btn-outline-primary category-link'>",
      "                        <?php echo htmlspecialchars(\\$cat['category']); ?>",
      "                    </a>",
      "                <?php endforeach; ?>",
      "                <a href='catalog.php' class='btn btn-outline-secondary category-link'>Все товары</a>",
      "            </div>",
      "        </div>",
      "",
      "        <!-- Популярные товары -->",
      "        <div class='mt-5'>",
      "            <h3 class='text-center mb-4'><i class='fas fa-fire'></i> Популярные товары</h3>",
      "            <div class='row'>",
      "                <?php if (empty(\\$popular_items)): ?>",
      "                    <div class='col-12'><div class='alert alert-info'>Нет товаров для отображения</div></div>",
      "                <?php else: ?>",
      "                    <?php foreach (\\$popular_items as \\$item): ?>",
      "                        <div class='col-md-3'>",
      "                            <div class='card h-100'>",
      "                                <img src='images/<?php echo \\$item['image'] ?? 'placeholder.jpg'; ?>' class='card-img-top' alt='<?php echo \\$item['name']; ?>'>",
      "                                <div class='card-body'>",
      "                                    <h5 class='card-title'><?php echo htmlspecialchars(\\$item['name']); ?></h5>",
      "                                    <p class='card-text'><?php echo mb_substr(htmlspecialchars(\\$item['description']), 0, 80); ?>...</p>",
      "                                    <p class='price'><?php echo number_format(\\$item['price'], 2); ?> ₽</p>",
      "                                    <?php if (isLoggedIn()): ?>",
      "                                        <form action='add_to_cart.php' method='POST'>",
      "                                            <input type='hidden' name='item_id' value='<?php echo \\$item['id']; ?>'>",
      "                                            <button type='submit' class='btn btn-sm btn-primary w-100'><i class='fas fa-cart-plus'></i> В корзину</button>",
      "                                        </form>",
      "                                    <?php else: ?>",
      "                                        <a href='login.php' class='btn btn-sm btn-secondary w-100'>Войдите для покупки</a>",
      "                                    <?php endif; ?>",
      "                                </div>",
      "                            </div>",
      "                        </div>",
      "                    <?php endforeach; ?>",
      "                <?php endif; ?>",
      "            </div>",
      "        </div>",
      "",
      "        <!-- Дополнительный блок: описание магазина -->",
      "        <div class='row mt-5 mb-5 text-center'>",
      "            <div class='col-md-4'>",
      "                <i class='fas fa-truck fa-3x text-primary'></i>",
      "                <h5>Быстрая доставка</h5>",
      "                <p>Доставим за 1-3 дня</p>",
      "            </div>",
      "            <div class='col-md-4'>",
      "                <i class='fas fa-credit-card fa-3x text-success'></i>",
      "                <h5>Удобная оплата</h5>",
      "                <p>Наличными, картой, онлайн</p>",
      "            </div>",
      "            <div class='col-md-4'>",
      "                <i class='fas fa-headset fa-3x text-warning'></i>",
      "                <h5>Поддержка 24/7</h5>",
      "                <p>Всегда на связи</p>",
      "            </div>",
      "        </div>",
      "    </div>",
      "",
      "    <!-- Footer -->",
      "    <footer class='bg-dark text-white text-center py-3 mt-4'>",
      "        <p>&copy; <?php echo date('Y'); ?> Мой Магазин. Все права защищены.</p>",
      "    </footer>",
      "",
      "    <script src='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js'></script>",
      "</body>",
      "</html>"
    ],
    "description": "[STORE] Главная страница с приветствием, категориями, поиском и популярными товарами"
  },

  "═════ 13. КАТАЛОГ УСЛУГ [BOOKING] ═════": {
    "prefix": "booking-catalog-skeleton",
    "body": [
      "<?php",
      "require_once 'config.php';",
      "",
      "// Фильтрация услуг",
      "\\$where = 'WHERE is_active = 1';",
      "\\$params = [];",
      "",
      "if (isset(\\$_GET['category']) && !empty(\\$_GET['category'])) {",
      "    \\$where .= ' AND category = ?';",
      "    \\$params[] = \\$_GET['category'];",
      "}",
      "",
      "if (isset(\\$_GET['search']) && !empty(\\$_GET['search'])) {",
      "    \\$where .= ' AND name LIKE ?';",
      "    \\$params[] = '%' . \\$_GET['search'] . '%';",
      "}",
      "",
      "\\$stmt = \\$pdo->prepare('SELECT * FROM items ' . \\$where . ' ORDER BY id DESC');",
      "\\$stmt->execute(\\$params);",
      "\\$services = \\$stmt->fetchAll();",
      "",
      "// Получение категорий услуг",
      "\\$categories = \\$pdo->query('SELECT DISTINCT category FROM items WHERE category IS NOT NULL')->fetchAll();",
      "?>",
      "<!DOCTYPE html>",
      "<html lang='ru'>",
      "<head>",
      "    <meta charset='UTF-8'>",
      "    <meta name='viewport' content='width=device-width, initial-scale=1'>",
      "    <title>Наши услуги - Бронирование</title>",
      "    <link href='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css' rel='stylesheet'>",
      "    <link rel='stylesheet' href='https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css'>",
      "    <style>",
      "        .navbar { background: #2c3e50 !important; }",
      "        .service-card { transition: transform 0.3s, box-shadow 0.3s; margin-bottom: 20px; cursor: pointer; }",
      "        .service-card:hover { transform: translateY(-10px); box-shadow: 0 10px 20px rgba(0,0,0,0.2); }",
      "        .service-img { height: 200px; object-fit: cover; }",
      "        .price { font-size: 1.8rem; color: #e67e22; font-weight: bold; }",
      "        .booking-btn { background: #28a745; color: white; }",
      "        .booking-btn:hover { background: #218838; }",
      "        .duration-badge { position: absolute; top: 10px; right: 10px; background: rgba(0,0,0,0.7); color: white; padding: 5px 10px; border-radius: 5px; font-size: 0.8rem; }",
      "        .fade-in { animation: fadeIn 0.5s ease; }",
      "        @keyframes fadeIn { from { opacity: 0; } to { opacity: 1; } }",
      "    </style>",
      "</head>",
      "<body>",
      "    <nav class='navbar navbar-expand-lg navbar-dark'>",
      "        <div class='container'>",
      "            <a class='navbar-brand' href='booking-index.php'><i class='fas fa-calendar-alt'></i> СервисБронь</a>",
      "            <div class='navbar-nav ms-auto'>",
      "                <?php if (isLoggedIn()): ?>",
      "                    <span class='nav-link text-light'>Привет, <?php echo htmlspecialchars(\\$_SESSION['full_name']); ?>!</span>",
      "                    <a class='nav-link' href='booking-cart.php'><i class='fas fa-shopping-bag'></i> Мои брони</a>",
      "                    <a class='nav-link' href='booking-orders.php'>Мои записи</a>",
      "                    <?php if (isAdmin()): ?>",
      "                        <a class='nav-link text-warning' href='booking-admin.php'><i class='fas fa-user-shield'></i> Админ</a>",
      "                    <?php endif; ?>",
      "                    <a class='nav-link' href='logout.php'>Выход</a>",
      "                <?php else: ?>",
      "                    <a class='nav-link' href='login.php'>Вход</a>",
      "                    <a class='nav-link' href='register.php'>Регистрация</a>",
      "                <?php endif; ?>",
      "            </div>",
      "        </div>",
      "    </nav>",
      "",
      "    <div class='container mt-4'>",
      "        <div class='row'>",
      "            <!-- Sidebar с фильтрами -->",
      "            <div class='col-md-3'>",
      "                <div class='card'>",
      "                    <div class='card-header bg-info text-white'>",
      "                        <h5><i class='fas fa-filter'></i> Фильтры услуг</h5>",
      "                    </div>",
      "                    <div class='card-body'>",
      "                        <form method='GET'>",
      "                            <div class='mb-3'>",
      "                                <label>Поиск услуги</label>",
      "                                <input type='text' name='search' class='form-control' placeholder='Название...' value='<?php echo \\$_GET['search'] ?? ''; ?>'>",
      "                            </div>",
      "                            <div class='mb-3'>",
      "                                <label>Категория</label>",
      "                                <select name='category' class='form-select'>",
      "                                    <option value=''>Все услуги</option>",
      "                                    <?php foreach (\\$categories as \\$cat): ?>",
      "                                        <option value='<?php echo \\$cat['category']; ?>' <?php echo (isset(\\$_GET['category']) && \\$_GET['category'] == \\$cat['category']) ? 'selected' : ''; ?>>",
      "                                            <?php echo \\$cat['category']; ?>",
      "                                        </option>",
      "                                    <?php endforeach; ?>",
      "                                </select>",
      "                            </div>",
      "                            <button type='submit' class='btn btn-info w-100 text-white'><i class='fas fa-search'></i> Найти услуги</button>",
      "                        </form>",
      "                    </div>",
      "                </div>",
      "                <div class='card mt-3'>",
      "                    <div class='card-body text-center'>",
      "                        <i class='fas fa-clock fa-2x text-info'></i>",
      "                        <p class='mt-2'>Работаем:<br>Пн-Вс: 09:00 - 21:00</p>",
      "                    </div>",
      "                </div>",
      "            </div>",
      "",
      "            <!-- Каталог услуг -->",
      "            <div class='col-md-9'>",
      "                <h1 class='mb-4 fade-in'><i class='fas fa-concierge-bell'></i> Наши услуги</h1>",
      "                <div class='row'>",
      "                    <?php if (empty(\\$services)): ?>",
      "                        <div class='alert alert-info'>Услуги не найдены</div>",
      "                    <?php else: ?>",
      "                        <?php foreach (\\$services as \\$service): ?>",
      "                            <div class='col-md-6 fade-in'>",
      "                                <div class='card service-card h-100'>",
      "                                    <div class='position-relative'>",
      "                                        <img src='images/<?php echo \\$service['image'] ?? 'service-placeholder.jpg'; ?>' class='card-img-top service-img' alt='<?php echo \\$service['name']; ?>'>",
      "                                        <span class='duration-badge'><i class='far fa-clock'></i> 60 мин</span>",
      "                                    </div>",
      "                                    <div class='card-body'>",
      "                                        <h5 class='card-title'><?php echo htmlspecialchars(\\$service['name']); ?></h5>",
      "                                        <p class='card-text'><?php echo htmlspecialchars(\\$service['description']); ?></p>",
      "                                        <p class='price'><?php echo number_format(\\$service['price'], 2); ?> ₽</p>",
      "                                        <p class='text-muted'>Свободно слотов: <?php echo \\$service['stock']; ?></p>",
      "                                        <?php if (isLoggedIn()): ?>",
      "                                            <a href='booking-step1.php?service_id=<?php echo \\$service['id']; ?>' class='btn booking-btn w-100'>",
      "                                                <i class='fas fa-calendar-check'></i> Забронировать",
      "                                            </a>",
      "                                        <?php else: ?>",
      "                                            <a href='login.php' class='btn btn-secondary w-100'>Войдите для бронирования</a>",
      "                                        <?php endif; ?>",
      "                                    </div>",
      "                                </div>",
      "                            </div>",
      "                        <?php endforeach; ?>",
      "                    <?php endif; ?>",
      "                </div>",
      "            </div>",
      "        </div>",
      "    </div>",
      "",
      "    <script src='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js'></script>",
      "</body>",
      "</html>"
    ],
    "description": "[BOOKING] Каталог услуг для бронирования"
  },

  "═════ 14. ШАГ 1: ВЫБОР ДАТЫ И ВРЕМЕНИ [BOOKING] ═════": {
    "prefix": "booking-step1-skeleton",
    "body": [
      "<?php",
      "require_once 'config.php';",
      "",
      "if (!isLoggedIn()) {",
      "    redirect('login.php');",
      "}",
      "",
      "\\$service_id = (int)(\\$_GET['service_id'] ?? 0);",
      "",
      "// Получение информации об услуге",
      "\\$stmt = \\$pdo->prepare('SELECT * FROM items WHERE id = ? AND is_active = 1');",
      "\\$stmt->execute([\\$service_id]);",
      "\\$service = \\$stmt->fetch();",
      "",
      "if (!\\$service) {",
      "    redirect('booking-catalog.php');",
      "}",
      "",
      "// Генерация доступных дат (следующие 14 дней)",
      "\\$available_dates = [];",
      "for (\\$i = 0; \\$i <= 14; \\$i++) {",
      "    \\$date = date('Y-m-d', strtotime('+' . \\$i . ' days'));",
      "    \\$dayOfWeek = date('N', strtotime(\\$date));",
      "    if (\\$dayOfWeek < 6) { // Пн-Пт",
      "        \\$available_dates[] = \\$date;",
      "    }",
      "}",
      "",
      "// Доступные часы",
      "\\$available_times = [",
      "    '09:00', '10:00', '11:00', '12:00', '13:00',",
      "    '14:00', '15:00', '16:00', '17:00', '18:00', '19:00', '20:00'",
      "];",
      "",
      "if (\\$_SERVER['REQUEST_METHOD'] === 'POST') {",
      "    \\$_SESSION['booking'] = [",
      "        'service_id' => \\$service_id,",
      "        'service_name' => \\$service['name'],",
      "        'service_price' => \\$service['price'],",
      "        'booking_date' => \\$_POST['booking_date'],",
      "        'booking_time' => \\$_POST['booking_time'],",
      "        'quantity' => 1",
      "    ];",
      "    redirect('booking-cart.php');",
      "}",
      "?>",
      "<!DOCTYPE html>",
      "<html lang='ru'>",
      "<head>",
      "    <meta charset='UTF-8'>",
      "    <meta name='viewport' content='width=device-width, initial-scale=1'>",
      "    <title>Выбор времени - <?php echo htmlspecialchars(\\$service['name']); ?></title>",
      "    <link href='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css' rel='stylesheet'>",
      "    <link rel='stylesheet' href='https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css'>",
      "    <style>",
      "        body { background: #f0f2f5; }",
      "        .booking-card { border-radius: 15px; overflow: hidden; }",
      "        .date-btn, .time-btn { margin: 5px; transition: all 0.3s; }",
      "        .date-btn.active, .time-btn.active { background: #28a745; color: white; border-color: #28a745; }",
      "        .service-info { background: linear-gradient(135deg, #667eea 0%, #764ba2 100%); color: white; padding: 20px; border-radius: 10px; }",
      "    </style>",
      "</head>",
      "<body>",
      "    <div class='container mt-5'>",
      "        <div class='row justify-content-center'>",
      "            <div class='col-md-8'>",
      "                <div class='card booking-card shadow'>",
      "                    <div class='card-header bg-primary text-white'>",
      "                        <h4><i class='fas fa-calendar-alt'></i> Бронирование услуги</h4>",
      "                    </div>",
      "                    <div class='card-body'>",
      "                        <div class='service-info mb-4'>",
      "                            <h3><?php echo htmlspecialchars(\\$service['name']); ?></h3>",
      "                            <p><?php echo htmlspecialchars(\\$service['description']); ?></p>",
      "                            <h4 class='text-warning'><?php echo number_format(\\$service['price'], 2); ?> ₽</h4>",
      "                        </div>",
      "",
      "                        <form method='POST' id='bookingForm'>",
      "                            <div class='mb-4'>",
      "                                <label class='form-label fw-bold'><i class='fas fa-calendar-day'></i> Выберите дату:</label>",
      "                                <div class='d-flex flex-wrap'>",
      "                                    <?php foreach (\\$available_dates as \\$date): ?>",
      "                                        <button type='button' class='btn btn-outline-primary date-btn' data-date='<?php echo \\$date; ?>'>",
      "                                            <?php echo date('d.m (D)', strtotime(\\$date)); ?>",
      "                                        </button>",
      "                                    <?php endforeach; ?>",
      "                                </div>",
      "                                <input type='hidden' name='booking_date' id='selected_date' required>",
      "                            </div>",
      "",
      "                            <div class='mb-4'>",
      "                                <label class='form-label fw-bold'><i class='fas fa-clock'></i> Выберите время:</label>",
      "                                <div class='d-flex flex-wrap'>",
      "                                    <?php foreach (\\$available_times as \\$time): ?>",
      "                                        <button type='button' class='btn btn-outline-success time-btn' data-time='<?php echo \\$time; ?>'>",
      "                                            <?php echo \\$time; ?>",
      "                                        </button>",
      "                                    <?php endforeach; ?>",
      "                                </div>",
      "                                <input type='hidden' name='booking_time' id='selected_time' required>",
      "                            </div>",
      "",
      "                            <button type='submit' class='btn btn-success btn-lg w-100' id='submitBtn' disabled>",
      "                                <i class='fas fa-arrow-right'></i> Продолжить бронирование",
      "                            </button>",
      "                        </form>",
      "                    </div>",
      "                </div>",
      "            </div>",
      "        </div>",
      "    </div>",
      "",
      "    <script>",
      "        let selectedDate = null;",
      "        let selectedTime = null;",
      "",
      "        document.querySelectorAll('.date-btn').forEach(btn => {",
      "            btn.addEventListener('click', function() {",
      "                document.querySelectorAll('.date-btn').forEach(b => b.classList.remove('active'));",
      "                this.classList.add('active');",
      "                selectedDate = this.dataset.date;",
      "                document.getElementById('selected_date').value = selectedDate;",
      "                checkSubmit();",
      "            });",
      "        });",
      "",
      "        document.querySelectorAll('.time-btn').forEach(btn => {",
      "            btn.addEventListener('click', function() {",
      "                document.querySelectorAll('.time-btn').forEach(b => b.classList.remove('active'));",
      "                this.classList.add('active');",
      "                selectedTime = this.dataset.time;",
      "                document.getElementById('selected_time').value = selectedTime;",
      "                checkSubmit();",
      "            });",
      "        });",
      "",
      "        function checkSubmit() {",
      "            const submitBtn = document.getElementById('submitBtn');",
      "            if (selectedDate && selectedTime) {",
      "                submitBtn.disabled = false;",
      "            } else {",
      "                submitBtn.disabled = true;",
      "            }",
      "        }",
      "    </script>",
      "    <script src='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js'></script>",
      "</body>",
      "</html>"
    ],
    "description": "[BOOKING] Шаг 1: выбор даты и времени услуги"
  },

  "═════ 15. КОРЗИНА БРОНИРОВАНИЙ [BOOKING] ═════": {
    "prefix": "booking-cart-skeleton",
    "body": [
      "<?php",
      "require_once 'config.php';",
      "",
      "if (!isLoggedIn()) {",
      "    redirect('login.php');",
      "}",
      "",
      "// Инициализация корзины бронирований",
      "if (!isset(\\$_SESSION['booking_cart'])) {",
      "    \\$_SESSION['booking_cart'] = [];",
      "}",
      "",
      "// Добавление в корзину бронирований",
      "if (isset(\\$_POST['add_booking'])) {",
      "    \\$booking_key = \\$_POST['service_id'] . '_' . \\$_POST['booking_date'] . '_' . \\$_POST['booking_time'];",
      "    \\$_SESSION['booking_cart'][\\$booking_key] = [",
      "        'service_id' => (int)\\$_POST['service_id'],",
      "        'service_name' => \\$_POST['service_name'],",
      "        'service_price' => (float)\\$_POST['service_price'],",
      "        'booking_date' => \\$_POST['booking_date'],",
      "        'booking_time' => \\$_POST['booking_time'],",
      "        'quantity' => 1",
      "    ];",
      "    redirect('booking-cart.php');",
      "}",
      "",
      "// Удаление из корзины",
      "if (isset(\\$_GET['remove'])) {",
      "    unset(\\$_SESSION['booking_cart'][\\$_GET['remove']]);",
      "    redirect('booking-cart.php');",
      "}",
      "",
      "// Очистка корзины",
      "if (isset(\\$_GET['clear'])) {",
      "    \\$_SESSION['booking_cart'] = [];",
      "    redirect('booking-cart.php');",
      "}",
      "",
      "// Расчет общей суммы",
      "\\$total = 0;",
      "foreach (\\$_SESSION['booking_cart'] as \\$booking) {",
      "    \\$total += \\$booking['service_price'];",
      "}",
      "?>",
      "<!DOCTYPE html>",
      "<html lang='ru'>",
      "<head>",
      "    <meta charset='UTF-8'>",
      "    <meta name='viewport' content='width=device-width, initial-scale=1'>",
      "    <title>Мои бронирования</title>",
      "    <link href='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css' rel='stylesheet'>",
      "    <link rel='stylesheet' href='https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css'>",
      "    <style>",
      "        .booking-item { border-left: 4px solid #28a745; margin-bottom: 15px; }",
      "        .total { font-size: 1.5rem; font-weight: bold; color: #28a745; }",
      "    </style>",
      "</head>",
      "<body>",
      "    <div class='container mt-4'>",
      "        <h1><i class='fas fa-shopping-bag'></i> Мои бронирования</h1>",
      "        <a href='booking-catalog.php' class='btn btn-secondary mb-3'><i class='fas fa-arrow-left'></i> Продолжить выбор</a>",
      "        <a href='?clear=1' class='btn btn-danger mb-3 float-end' onclick='return confirm(\"Очистить все бронирования?\")'>",
      "            <i class='fas fa-trash-alt'></i> Очистить",
      "        </a>",
      "",
      "        <?php if (empty(\\$_SESSION['booking_cart'])): ?>",
      "            <div class='alert alert-info'>У вас пока нет забронированных услуг</div>",
      "        <?php else: ?>",
      "            <div class='row'>",
      "                <div class='col-md-8'>",
      "                    <?php foreach (\\$_SESSION['booking_cart'] as \\$key => \\$booking): ?>",
      "                        <div class='card booking-item'>",
      "                            <div class='card-body'>",
      "                                <div class='row align-items-center'>",
      "                                    <div class='col-md-5'>",
      "                                        <h5><?php echo htmlspecialchars(\\$booking['service_name']); ?></h5>",
      "                                    </div>",
      "                                    <div class='col-md-3'>",
      "                                        <i class='fas fa-calendar-alt'></i> <?php echo date('d.m.Y', strtotime(\\$booking['booking_date'])); ?><br>",
      "                                        <i class='fas fa-clock'></i> <?php echo \\$booking['booking_time']; ?>",
      "                                    </div>",
      "                                    <div class='col-md-2'>",
      "                                        <h5><?php echo number_format(\\$booking['service_price'], 2); ?> ₽</h5>",
      "                                    </div>",
      "                                    <div class='col-md-2 text-end'>",
      "                                        <a href='?remove=<?php echo urlencode(\\$key); ?>' class='btn btn-sm btn-danger' onclick='return confirm(\"Удалить бронирование?\")'>",
      "                                            <i class='fas fa-times'></i> Удалить",
      "                                        </a>",
      "                                    </div>",
      "                                </div>",
      "                            </div>",
      "                        </div>",
      "                    <?php endforeach; ?>",
      "                </div>",
      "",
      "                <div class='col-md-4'>",
      "                    <div class='card bg-light'>",
      "                        <div class='card-body'>",
      "                            <h5>Итого к оплате</h5>",
      "                            <p class='total'><?php echo number_format(\\$total, 2); ?> ₽</p>",
      "                            <hr>",
      "                            <p><i class='fas fa-info-circle'></i> Вы бронируете <?php echo count(\\$_SESSION['booking_cart']); ?> услуг(у)</p>",
      "                            <a href='booking-checkout.php' class='btn btn-success w-100 btn-lg'>",
      "                                <i class='fas fa-check-circle'></i> Подтвердить бронирование",
      "                            </a>",
      "                        </div>",
      "                    </div>",
      "                </div>",
      "            </div>",
      "        <?php endif; ?>",
      "    </div>",
      "    <script src='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js'></script>",
      "</body>",
      "</html>"
    ],
    "description": "[BOOKING] Корзина бронирований услуг"
  },

  "═════ 16. ОФОРМЛЕНИЕ БРОНИРОВАНИЯ [BOOKING] ═════": {
    "prefix": "booking-checkout-skeleton",
    "body": [
      "<?php",
      "require_once 'config.php';",
      "",
      "if (!isLoggedIn()) {",
      "    redirect('login.php');",
      "}",
      "",
      "if (empty(\\$_SESSION['booking_cart'])) {",
      "    redirect('booking-catalog.php');",
      "}",
      "",
      "// Получение данных пользователя",
      "\\$stmt = \\$pdo->prepare('SELECT * FROM users WHERE id = ?');",
      "\\$stmt->execute([\\$_SESSION['user_id']]);",
      "\\$user = \\$stmt->fetch();",
      "",
      "if (\\$_SERVER['REQUEST_METHOD'] === 'POST') {",
      "    \\$address = trim(\\$_POST['address'] ?? '');",
      "    \\$notes = trim(\\$_POST['notes'] ?? '');",
      "    \\$payment_method = \\$_POST['payment_method'] ?? 'cash';",
      "",
      "    // Расчет общей суммы",
      "    \\$total = 0;",
      "    foreach (\\$_SESSION['booking_cart'] as \\$booking) {",
      "        \\$total += \\$booking['service_price'];",
      "    }",
      "",
      "    // Сохранение заказа (бронирования)",
      "    \\$pdo->beginTransaction();",
      "    try {",
      "        \\$stmt = \\$pdo->prepare('INSERT INTO orders (user_id, total_amount, status, delivery_address, notes, payment_method) VALUES (?, ?, ?, ?, ?, ?)');",
      "        \\$stmt->execute([\\$_SESSION['user_id'], \\$total, 'confirmed', \\$address, \\$notes, \\$payment_method]);",
      "        \\$order_id = \\$pdo->lastInsertId();",
      "",
      "        foreach (\\$_SESSION['booking_cart'] as \\$booking) {",
      "            \\$stmt = \\$pdo->prepare('INSERT INTO order_items (order_id, item_id, quantity, price) VALUES (?, ?, ?, ?)');",
      "            \\$stmt->execute([\\$order_id, \\$booking['service_id'], 1, \\$booking['service_price']]);",
      "",
      "            // Обновление времени бронирования в notes (можно создать отдельную таблицу)",
      "            \\$booking_info = 'Дата: ' . \\$booking['booking_date'] . ', Время: ' . \\$booking['booking_time'] . '; ';",
      "            \\$pdo->prepare('UPDATE orders SET notes = CONCAT(IFNULL(notes, \"\"), ?) WHERE id = ?')",
      "                ->execute([\\$booking_info, \\$order_id]);",
      "        }",
      "",
      "        \\$pdo->commit();",
      "        \\$_SESSION['booking_cart'] = [];",
      "        \\$_SESSION['message'] = 'Бронирование №' . \\$order_id . ' успешно оформлено! Ожидайте подтверждения.';",
      "        redirect('booking-orders.php');",
      "    } catch (Exception \\$e) {",
      "        \\$pdo->rollBack();",
      "        \\$error = 'Ошибка при бронировании: ' . \\$e->getMessage();",
      "    }",
      "}",
      "?>",
      "<!DOCTYPE html>",
      "<html lang='ru'>",
      "<head>",
      "    <meta charset='UTF-8'>",
      "    <meta name='viewport' content='width=device-width, initial-scale=1'>",
      "    <title>Оформление бронирования</title>",
      "    <link href='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css' rel='stylesheet'>",
      "    <link rel='stylesheet' href='https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css'>",
      "</head>",
      "<body>",
      "    <div class='container mt-4'>",
      "        <h1><i class='fas fa-clipboard-list'></i> Оформление бронирования</h1>",
      "        <div class='row'>",
      "            <div class='col-md-6'>",
      "                <div class='card'>",
      "                    <div class='card-header bg-success text-white'>",
      "                        <h5>Контактные данные</h5>",
      "                    </div>",
      "                    <div class='card-body'>",
      "                        <?php if (isset(\\$error)): ?>",
      "                            <div class='alert alert-danger'><?php echo \\$error; ?></div>",
      "                        <?php endif; ?>",
      "                        <form method='POST'>",
      "                            <div class='mb-3'>",
      "                                <label>Ваше имя</label>",
      "                                <input type='text' class='form-control' value='<?php echo htmlspecialchars(\\$user['full_name']); ?>' disabled>",
      "                            </div>",
      "                            <div class='mb-3'>",
      "                                <label>Телефон</label>",
      "                                <input type='text' class='form-control' value='<?php echo htmlspecialchars(\\$user['phone']); ?>' disabled>",
      "                            </div>",
      "                            <div class='mb-3'>",
      "                                <label>Email</label>",
      "                                <input type='email' class='form-control' value='<?php echo htmlspecialchars(\\$user['email']); ?>' disabled>",
      "                            </div>",
      "                            <div class='mb-3'>",
      "                                <label>Адрес (если услуга на выезд)</label>",
      "                                <textarea name='address' class='form-control' rows='2' placeholder='Ваш адрес...'></textarea>",
      "                            </div>",
      "                            <div class='mb-3'>",
      "                                <label>Способ оплаты</label>",
      "                                <select name='payment_method' class='form-select'>",
      "                                    <option value='cash'>Наличными</option>",
      "                                    <option value='card'>Картой</option>",
      "                                    <option value='online'>Онлайн предоплата</option>",
      "                                </select>",
      "                            </div>",
      "                            <div class='mb-3'>",
      "                                <label>Комментарий к бронированию</label>",
      "                                <textarea name='notes' class='form-control' rows='2' placeholder='Дополнительные пожелания...'></textarea>",
      "                            </div>",
      "                            <button type='submit' class='btn btn-success w-100'><i class='fas fa-check-circle'></i> Подтвердить бронь</button>",
      "                            <a href='booking-cart.php' class='btn btn-secondary w-100 mt-2'>Назад к броням</a>",
      "                        </form>",
      "                    </div>",
      "                </div>",
      "            </div>",
      "",
      "            <div class='col-md-6'>",
      "                <div class='card'>",
      "                    <div class='card-header bg-info text-white'>",
      "                        <h5><i class='fas fa-list'></i> Ваши услуги</h5>",
      "                    </div>",
      "                    <div class='card-body'>",
      "                        <?php foreach (\\$_SESSION['booking_cart'] as \\$booking): ?>",
      "                            <div class='mb-3 pb-2 border-bottom'>",
      "                                <strong><?php echo htmlspecialchars(\\$booking['service_name']); ?></strong><br>",
      "                                <small><i class='fas fa-calendar'></i> <?php echo date('d.m.Y', strtotime(\\$booking['booking_date'])); ?></small><br>",
      "                                <small><i class='fas fa-clock'></i> <?php echo \\$booking['booking_time']; ?></small><br>",
      "                                <strong class='text-success'><?php echo number_format(\\$booking['service_price'], 2); ?> ₽</strong>",
      "                            </div>",
      "                        <?php endforeach; ?>",
      "                        <hr>",
      "                        <h4 class='text-end'>Итого: <?php echo number_format(array_sum(array_column(\\$_SESSION['booking_cart'], 'service_price')), 2); ?> ₽</h4>",
      "                    </div>",
      "                </div>",
      "            </div>",
      "        </div>",
      "    </div>",
      "    <script src='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js'></script>",
      "</body>",
      "</html>"
    ],
    "description": "[BOOKING] Оформление бронирования услуг"
  },

  "═════ 17. МОИ БРОНИРОВАНИЯ [BOOKING] ═════": {
    "prefix": "booking-orders-skeleton",
    "body": [
      "<?php",
      "require_once 'config.php';",
      "",
      "if (!isLoggedIn()) {",
      "    redirect('login.php');",
      "}",
      "",
      "\\$stmt = \\$pdo->prepare('SELECT * FROM orders WHERE user_id = ? ORDER BY created_at DESC');",
      "\\$stmt->execute([\\$_SESSION['user_id']]);",
      "\\$orders = \\$stmt->fetchAll();",
      "?>",
      "<!DOCTYPE html>",
      "<html lang='ru'>",
      "<head>",
      "    <meta charset='UTF-8'>",
      "    <meta name='viewport' content='width=device-width, initial-scale=1'>",
      "    <title>Мои бронирования</title>",
      "    <link href='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css' rel='stylesheet'>",
      "    <link rel='stylesheet' href='https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css'>",
      "    <style>",
      "        .booking-card { transition: all 0.3s; }",
      "        .booking-card:hover { transform: translateX(5px); }",
      "        .status-confirmed { background: #28a745; color: white; }",
      "        .status-new { background: #ffc107; color: black; }",
      "        .status-cancelled { background: #dc3545; color: white; }",
      "        .status-completed { background: #17a2b8; color: white; }",
      "    </style>",
      "</head>",
      "<body>",
      "    <div class='container mt-4'>",
      "        <h1><i class='fas fa-calendar-check'></i> Мои бронирования</h1>",
      "        <a href='booking-catalog.php' class='btn btn-primary mb-3'><i class='fas fa-plus-circle'></i> Новая запись</a>",
      "",
      "        <?php if (isset(\\$_SESSION['message'])): ?>",
      "            <div class='alert alert-success'><?php echo \\$_SESSION['message']; unset(\\$_SESSION['message']); ?></div>",
      "        <?php endif; ?>",
      "",
      "        <?php if (empty(\\$orders)): ?>",
      "            <div class='alert alert-info'>У вас пока нет бронирований</div>",
      "        <?php else: ?>",
      "            <div class='row'>",
      "                <?php foreach (\\$orders as \\$order): ?>",
      "                    <div class='col-md-6 mb-3'>",
      "                        <div class='card booking-card'>",
      "                            <div class='card-header d-flex justify-content-between align-items-center'>",
      "                                <strong><i class='fas fa-ticket-alt'></i> Бронь №<?php echo \\$order['id']; ?></strong>",
      "                                <span class='badge status-<?php echo \\$order['status']; ?> p-2'>",
      "                                    <?php",
      "                                        \\$statuses = ['new' => 'Новая', 'confirmed' => 'Подтверждена', 'processing' => 'В обработке', 'completed' => 'Выполнена', 'cancelled' => 'Отменена'];",
      "                                        echo \\$statuses[\\$order['status']];",
      "                                    ?>",
      "                                </span>",
      "                            </div>",
      "                            <div class='card-body'>",
      "                                <p><strong>Сумма:</strong> <?php echo number_format(\\$order['total_amount'], 2); ?> ₽</p>",
      "                                <p><strong>Дата брони:</strong> <?php echo date('d.m.Y H:i', strtotime(\\$order['created_at'])); ?></p>",
      "                                <?php if (!empty(\\$order['notes'])): ?>",
      "                                    <p><strong>Детали:</strong> <?php echo nl2br(htmlspecialchars(\\$order['notes'])); ?></p>",
      "                                <?php endif; ?>",
      "                                <hr>",
      "                                <small class='text-muted'>Статус можно отслеживать в личном кабинете</small>",
      "                            </div>",
      "                        </div>",
      "                    </div>",
      "                <?php endforeach; ?>",
      "            </div>",
      "        <?php endif; ?>",
      "    </div>",
      "    <script src='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js'></script>",
      "</body>",
      "</html>"
    ],
    "description": "[BOOKING] Страница моих бронирований"
  },

  "═════ 18. ГЛАВНАЯ [BOOKING] ═════": {
    "prefix": "booking-index-skeleton",
    "body": [
      "<?php",
      "require_once 'config.php';",
      "",
      "// Получение популярных услуг",
      "\\$popular_services = \\$pdo->query('SELECT * FROM items WHERE is_active = 1 ORDER BY id DESC LIMIT 3')->fetchAll();",
      "?>",
      "<!DOCTYPE html>",
      "<html lang='ru'>",
      "<head>",
      "    <meta charset='UTF-8'>",
      "    <meta name='viewport' content='width=device-width, initial-scale=1'>",
      "    <title>СервисБронь - Запись на услуги</title>",
      "    <link href='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css' rel='stylesheet'>",
      "    <link rel='stylesheet' href='https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css'>",
      "    <style>",
      "        .hero { background: linear-gradient(135deg, #667eea 0%, #764ba2 100%); color: white; padding: 80px 0; text-align: center; }",
      "        .feature-icon { font-size: 3rem; margin-bottom: 20px; }",
      "        .service-card { transition: transform 0.3s; }",
      "        .service-card:hover { transform: translateY(-10px); }",
      "        .btn-booking { background: #28a745; color: white; }",
      "        .btn-booking:hover { background: #218838; color: white; }",
      "    </style>",
      "</head>",
      "<body>",
      "    <nav class='navbar navbar-expand-lg navbar-dark bg-dark'>",
      "        <div class='container'>",
      "            <a class='navbar-brand' href='booking-index.php'><i class='fas fa-calendar-alt'></i> СервисБронь</a>",
      "            <div class='navbar-nav ms-auto'>",
      "                <?php if (isLoggedIn()): ?>",
      "                    <span class='nav-link text-light'>Привет, <?php echo htmlspecialchars(\\$_SESSION['full_name']); ?>!</span>",
      "                    <a class='nav-link' href='booking-cart.php'><i class='fas fa-shopping-bag'></i> Мои брони</a>",
      "                    <a class='nav-link' href='booking-orders.php'>Мои записи</a>",
      "                    <?php if (isAdmin()): ?>",
      "                        <a class='nav-link text-warning' href='booking-admin.php'><i class='fas fa-user-shield'></i> Админ</a>",
      "                    <?php endif; ?>",
      "                    <a class='nav-link' href='logout.php'>Выход</a>",
      "                <?php else: ?>",
      "                    <a class='nav-link' href='login.php'>Вход</a>",
      "                    <a class='nav-link' href='register.php'>Регистрация</a>",
      "                <?php endif; ?>",
      "            </div>",
      "        </div>",
      "    </nav>",
      "",
      "    <div class='hero'>",
      "        <div class='container'>",
      "            <h1><i class='fas fa-concierge-bell'></i> СервисБронь</h1>",
      "            <p>Быстрая и удобная запись на услуги в несколько кликов</p>",
      "            <a href='booking-catalog.php' class='btn btn-light btn-lg'><i class='fas fa-search'></i> Выбрать услугу</a>",
      "        </div>",
      "    </div>",
      "",
      "    <div class='container mt-5'>",
      "        <div class='row text-center mb-5'>",
      "            <div class='col-md-4'>",
      "                <i class='fas fa-clock feature-icon text-primary'></i>",
      "                <h5>Выберите удобное время</h5>",
      "                <p>Записывайтесь на любое свободное время</p>",
      "            </div>",
      "            <div class='col-md-4'>",
      "                <i class='fas fa-check-circle feature-icon text-success'></i>",
      "                <h5>Подтверждение за 5 минут</h5>",
      "                <p>Быстрое подтверждение брони</p>",
      "            </div>",
      "            <div class='col-md-4'>",
      "                <i class='fas fa-headset feature-icon text-info'></i>",
      "                <h5>Поддержка 24/7</h5>",
      "                <p>Всегда готовы помочь</p>",
      "            </div>",
      "        </div>",
      "",
      "        <h3 class='text-center mb-4'>Популярные услуги</h3>",
      "        <div class='row'>",
      "            <?php foreach (\\$popular_services as \\$service): ?>",
      "                <div class='col-md-4'>",
      "                    <div class='card service-card mb-4'>",
      "                        <img src='images/<?php echo \\$service['image'] ?? 'service-placeholder.jpg'; ?>' class='card-img-top' style='height: 200px; object-fit: cover;'>",
      "                        <div class='card-body'>",
      "                            <h5><?php echo htmlspecialchars(\\$service['name']); ?></h5>",
      "                            <p class='text-muted'><?php echo mb_substr(htmlspecialchars(\\$service['description']), 0, 80); ?></p>",
      "                            <p class='h4 text-success'><?php echo number_format(\\$service['price'], 2); ?> ₽</p>",
      "                            <a href='booking-step1.php?service_id=<?php echo \\$service['id']; ?>' class='btn btn-booking w-100'>Забронировать</a>",
      "                        </div>",
      "                    </div>",
      "                </div>",
      "            <?php endforeach; ?>",
      "        </div>",
      "    </div>",
      "",
      "    <footer class='bg-dark text-white text-center py-3 mt-5'>",
      "        <p>&copy; <?php echo date('Y'); ?> СервисБронь - Удобная запись на услуги</p>",
      "    </footer>",
      "    <script src='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js'></script>",
      "</body>",
      "</html>"
    ],
    "description": "[BOOKING] Главная страница сервиса бронирования"
  },

  "═════ 19. АДМИН-ПАНЕЛЬ [BOOKING] ═════": {
    "prefix": "booking-admin-skeleton",
    "body": [
      "<?php",
      "require_once 'config.php';",
      "",
      "if (!isAdmin()) {",
      "    redirect('login.php');",
      "}",
      "",
      "// Изменение статуса бронирования",
      "if (isset(\\$_GET['change_status']) && isset(\\$_GET['status'])) {",
      "    \\$stmt = \\$pdo->prepare('UPDATE orders SET status = ? WHERE id = ?');",
      "    \\$stmt->execute([\\$_GET['status'], \\$_GET['change_status']]);",
      "    redirect('booking-admin.php');",
      "}",
      "",
      "// Управление услугами",
      "if (isset(\\$_POST['add_service'])) {",
      "    \\$stmt = \\$pdo->prepare('INSERT INTO items (name, description, price, stock, category) VALUES (?, ?, ?, ?, ?)');",
      "    \\$stmt->execute([\\$_POST['name'], \\$_POST['description'], \\$_POST['price'], \\$_POST['stock'], \\$_POST['category']]);",
      "    \\$_SESSION['message'] = 'Услуга добавлена!';",
      "    redirect('booking-admin.php');",
      "}",
      "",
      "if (isset(\\$_GET['delete_service'])) {",
      "    \\$stmt = \\$pdo->prepare('DELETE FROM items WHERE id = ?');",
      "    \\$stmt->execute([\\$_GET['delete_service']]);",
      "    \\$_SESSION['message'] = 'Услуга удалена!';",
      "    redirect('booking-admin.php');",
      "}",
      "",
      "// Получение бронирований",
      "\\$bookings = \\$pdo->query('",
      "    SELECT o.*, u.full_name, u.email, u.phone ",
      "    FROM orders o ",
      "    JOIN users u ON o.user_id = u.id ",
      "    ORDER BY o.created_at DESC",
      "')->fetchAll();",
      "",
      "\\$services = \\$pdo->query('SELECT * FROM items ORDER BY id DESC')->fetchAll();",
      "",
      "\\$stats = [",
      "    'total' => \\$pdo->query('SELECT COUNT(*) FROM orders')->fetchColumn(),",
      "    'confirmed' => \\$pdo->query(\"SELECT COUNT(*) FROM orders WHERE status = 'confirmed'\")->fetchColumn(),",
      "    'today' => \\$pdo->query(\"SELECT COUNT(*) FROM orders WHERE DATE(created_at) = CURDATE()\")->fetchColumn()",
      "];",
      "?>",
      "<!DOCTYPE html>",
      "<html lang='ru'>",
      "<head>",
      "    <meta charset='UTF-8'>",
      "    <meta name='viewport' content='width=device-width, initial-scale=1'>",
      "    <title>Админ-панель бронирований</title>",
      "    <link href='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css' rel='stylesheet'>",
      "    <link rel='stylesheet' href='https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css'>",
      "</head>",
      "<body>",
      "    <div class='container-fluid'>",
      "        <div class='row'>",
      "            <div class='col-md-2 bg-dark min-vh-100 p-0'>",
      "                <div class='text-center py-4'>",
      "                    <h4 class='text-white'><i class='fas fa-calendar-check'></i> Админ Бронь</h4>",
      "                </div>",
      "                <div class='list-group list-group-flush'>",
      "                    <a href='?tab=bookings' class='list-group-item list-group-item-action bg-dark text-white'>Бронирования</a>",
      "                    <a href='?tab=services' class='list-group-item list-group-item-action bg-dark text-white'>Услуги</a>",
      "                    <a href='?tab=add' class='list-group-item list-group-item-action bg-dark text-white'>+ Добавить услугу</a>",
      "                    <a href='logout.php' class='list-group-item list-group-item-action bg-dark text-danger'>Выход</a>",
      "                </div>",
      "            </div>",
      "",
      "            <div class='col-md-10 p-4'>",
      "                <div class='row mb-4'>",
      "                    <div class='col-md-4'><div class='card bg-primary text-white'><div class='card-body'><h5>Всего броней</h5><h2><?php echo \\$stats['total']; ?></h2></div></div></div>",
      "                    <div class='col-md-4'><div class='card bg-success text-white'><div class='card-body'><h5>Подтверждено</h5><h2><?php echo \\$stats['confirmed']; ?></h2></div></div></div>",
      "                    <div class='col-md-4'><div class='card bg-info text-white'><div class='card-body'><h5>Сегодня</h5><h2><?php echo \\$stats['today']; ?></h2></div></div></div>",
      "                </div>",
      "",
      "                <div class='card'>",
      "                    <div class='card-header bg-dark text-white'><h5><i class='fas fa-list'></i> Все бронирования</h5></div>",
      "                    <div class='card-body'>",
      "                        <table class='table'>",
      "                            <thead><tr><th>ID</th><th>Клиент</th><th>Сумма</th><th>Статус</th><th>Дата</th><th>Действия</th></tr></thead>",
      "                            <tbody>",
      "                                <?php foreach (\\$bookings as \\$booking): ?>",
      "                                    <tr><th><?php echo \\$booking['id']; ?></th>",
      "                                        <td><?php echo htmlspecialchars(\\$booking['full_name']); ?></td>",
      "                                        <td><?php echo number_format(\\$booking['total_amount'], 2); ?> ₽</td>",
      "                                        <td><span class='badge bg-<?php echo \\$booking['status'] == 'confirmed' ? 'success' : ($booking['status'] == 'cancelled' ? 'danger' : 'warning'); ?>'><?php echo \\$booking['status']; ?></span></td>",
      "                                        <td><?php echo date('d.m.Y', strtotime(\\$booking['created_at'])); ?></td>",
      "                                        <td>",
      "                                            <a href='?change_status=<?php echo \\$booking['id']; ?>&status=confirmed' class='btn btn-sm btn-success'>Подтвердить</a>",
      "                                            <a href='?change_status=<?php echo \\$booking['id']; ?>&status=cancelled' class='btn btn-sm btn-danger'>Отменить</a>",
      "                                            <a href='?change_status=<?php echo \\$booking['id']; ?>&status=completed' class='btn btn-sm btn-info'>Завершить</a>",
      "                                         </td>",
      "                                    </tr>",
      "                                <?php endforeach; ?>",
      "                            </tbody>",
      "                        </table>",
      "                    </div>",
      "                </div>",
      "            </div>",
      "        </div>",
      "    </div>",
      "    <script src='https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js'></script>",
      "</body>",
      "</html>"
    ],
    "description": "[BOOKING] Админ-панель для управления бронированиями"
  }
}